Thread
:
Top 3rd value
View Single Post
#
5
(
permalink
)
08-02-2007, 08:13 AM
Unregistered
Posts: n/a
ANY
answer.
Re: Top 3rd value
Quote:
Originally Posted by
Mahesh RG
Hello can any buddy tel me can i write a query to get the top 3rd, 4th value from the table 'emp'?
SELECT Min(qty) AS Expr1
FROM (select top 3 qty from cashmemodetail order by qty desc)
Unregistered
