SQL MAX() funct -
let's have list of workers in table workers(id, name, salary).
if want see name of guy highest salary, like:
select name ( select name, max(salary) workers ) t i wondering if using 1 select query? i'm sorry if it's dumb question, i'm new sql.
more 1 name salary = max(salary)
select top (1) ties name, salary workers order salary desc
Comments
Post a Comment