Ask your own question, for FREE!
Computer Science 20 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!
Latest Questions
Arriyanalol: i need help
1 day ago 7 Replies 1 Medal
Arriyanalol: CONGRATS to me
1 day ago 8 Replies 2 Medals
Legomaster346: What colleges are good that are near Arab Alabama?
1 week ago 5 Replies 0 Medals
Arriyanalol: i need help
1 week ago 6 Replies 2 Medals
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!