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

Popular posts from this blog

shopping cart - Page redirect not working PHP -

php - How to modify a menu to show sub-menus -

python - Installing PyDev in eclipse is failed -