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

Answer Posted / sudeep mishra

select *
from employee
where salary = max sal

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a temporal table?

497


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

550


what are the different tables present in mysql? : Sql dba

506


Can there be 2 primary keys in a table?

559


How many indexes can be created on a table in sql?

498






what is the difference between clustered and non clustered index in sql? : Sql dba

551


Why select is used in sql?

522


How can you save or place your msg in a table?

523


What is sql query optimization?

547


what is row? : Sql dba

714


How many sql statements are used?

570


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

604


What is sql trigger example?

543


When do we use triggers?

587


Do stored procedures prevent sql injection?

552