I have a derived attribute in my table and I'm sorting the table in the descending order of this attribute. My query should retrieve all the tuples which have the maximum value for this derived attribute.
If I use SELECT TOP 1, I'm only getting one of the required results. How can I get all the tuples with the maximum value ??
Thanks in advance..
EDIT*: The only problem I'm having in implementing this query is not being able to refer to the derived attribute in the WHERE clause. Can anyone tell me how it's done ?