hi, i have 3 cols in my db
col 1 ( unique identifier )
col2 ( varchar )
col 3 ( integer )
how can i retrive the 3 greatest values from the database on the basis of col 3..
bharatshivram
0
Light Poster
Recommended Answers
Jump to Postselect top 3 * from tableName order by col3 desc
All 2 Replies
dickersonka
104
Veteran Poster
select top 3 *
from tableName
order by col3 desc
bharatshivram
commented:
thanx for your reply.
+2
bharatshivram
0
Light Poster
thanx for your reply.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.