Hi,

I want the select statement but i am using group by but i don't want to use any aggregate function on it . kindly suggest me the answer.

select empno, ename from emp group by deptid,empno;

Thank You,

If every field in your select list is also in the group by, you don't need aggregate functions to tell the database how to collapse multiple rows. In that case, you're probably better off using select distinct.

Are you trying to sort your rows? If so, you want ORDER BY, not GROUP BY.

people talk about stuff i hav no clue about WAY too often.

oh, poo. I feel like a watermelon who dreamed she was a pickle.

anyways...

ignorance is bliss, right? ain't that good?