Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Dinesh Asanka Find Min/Max Values in a Set RE: Find Min/Max Values in a Set
baxi
Say Hey Kid
Points: 690
More actions
November 21, 2003 at 5:34 am
#483047
An other solution is:
declare @n int
select min(your_field) from your_table where your_field in
(select top @n your_field from your_table order by your_field desc)
For me is more elegant.
Adrian