could anypone please guide on this.
Can we use the scalar function say MAX in the where clause of a SELECT query to see a user with maximum values ?(or) we have to go for subquery with the inner query selecting the max value
select user from table
where value in
( select max(value) from table
Just have a doubt on the first part of the question.Help appreciated