Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Select Query

Author  Topic 

samhrishi
Starting Member

13 Posts

Posted - 2010-11-23 : 05:42:11
i have Table Eith Name EmpData
i want to Show Data as per employee last Name but it should be include orderby and distinct clause..


sam

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2010-11-23 : 05:47:43
select distinct *
from EmpData
order by LastName

Think you need to be a bit clearer about what you want and what you have tried yourself would be good.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

samhrishi
Starting Member

13 Posts

Posted - 2010-11-23 : 06:15:44
Thanks
nigelrivett

sam
Go to Top of Page
   

- Advertisement -