From an Employee table, how will you display the record
which has a maximum salary?

Answer Posted / jayshree

SELECT LAST_NAME,MAX(SALARY)
FROM EMPLOYEES
GROUP_BY SALARY;

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between inner join and cross join?

522


What are the possible values for the boolean data field?

527


Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

671


What is the purpose of design view?

527


describe mysql connection using mysql binary. : Sql dba

552






How do you rank data in sql?

517


How does cross join work?

504


What does varchar include?

519


What does data normalization mean?

537


How do we accept inputs from user during runtime?

548


How many commands are in sql?

529


What is sql engine in oracle?

524


what are the t string functions available in tsql? : Transact sql

545


what is timestamp in mysql? : Sql dba

568


How do you truncate?

507