By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,932 Members | 1,454 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,932 IT Pros & Developers. It's quick & easy.

Select last top 10 names from table registration and those names must be unique

P: 1
SELECT top 10 app_name from Registration order by slno desc

but using these query ... i get get duplicate name too... but i want unique names only.
Apr 17 '13 #1
Share this Question
Share on Google+
1 Reply

P: 158
Hey akashmukherjee, you can use like this,

Expand|Select|Wrap|Line Numbers
  1. SELECT TOP 10 app_name FROM ( SELECT DISTINCT app_name 
  2. FROM Registration) AS Temporary_Name ORDER BY slno DESC
Apr 17 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.