Ask your own question, for FREE!
Computer Science 9 Online
OpenStudy (anonymous):

What SQL query should be made to select a table entry with highest value? Suppose, we have table T1 which consists of fields Name and salary. What is the SQL query to select the name with maximum salary?

OpenStudy (anonymous):

select name from T1 where salary = (select max(salary) from T1) ;

OpenStudy (anonymous):

http://www.techonthenet.com/sql/having.php

Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!
Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!