greatest three

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..

Light Poster

35 posts since Mar 2007

Reputation Points: 10

Solved Threads: 1

select top 3 *
from tableName
order by col3 desc

Veteran Poster

1,175 posts since Aug 2008

Reputation Points: 130

Solved Threads: 143

thanx for your reply.

Light Poster

35 posts since Mar 2007

Reputation Points: 10

Solved Threads: 1

This question has already been solved

You