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
 i want display top values in single column

Author  Topic 

balajiram
Starting Member

1 Post

Posted - 2008-09-10 : 16:35:07
hai friends

i am having five different set of records in same tabe
now iwant to display top values from that record

pls help me very urgent

hey001us
Posting Yak Master

185 Posts

Posted - 2008-09-10 : 16:44:29
How to post a question for a database:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

hey
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-09-10 : 19:08:49
select top 5 * from your_table where x = 'y' order by inserted_date desc
Go to Top of Page
   

- Advertisement -