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

Answer Posted / anil

select * from test.emp where salary=(select max(salary) from test.emp);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a query and a report?

523


Explain some predefined exceptions.

588


What is sqlexception in java?

551


What do you mean by “trigger” in sql?

623


What is your daily office routine?

1813






What are sql queries used for?

536


What is difference between pls_integer and integer?

521


What is the use of triggers?

545


what is dbms? : Sql dba

545


Which join condition can be specified using on clause?

517


What is an exception in pl/sql?

544


What is minus?

547


What is $$ in sql?

555


How to run sql statements with oracle sql developer?

625


How to execute a stored procedure?

565