>Hi Sergey,
> That's an interesting idea, but it might not give a complete row. It could give some columns from one row and some columns from another row. I don't care which row it gives, but it has to be a complete row, that is, all the columns must come from a single row.
> Is there any other way to get around the GROUP BY constraint?


Hi Chaim,

Alan and Tamar gave you two ways to get result you need. To expand on Tamar's idea, if your table doesn't have prinary key, you'll have to run one more select to add record # to the key field and than run quieries she suggested.