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

Answer Posted / sayed

select top(1) * from emp order by salary desc

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is record type in pl sql?

540


which types of join is used in sql widely? : Sql dba

535


How to execute a stored procedure?

557


Can I join the same table twice?

522


What is structural independence and why is it important?

542






Explain the significance of the & and && operators in pl sql.

567


Why is pl sql needed?

503


Explain the working of foreign key?

540


Is keyword pl sql?

556


Can we use rowid as primary key?

539


What is sql and also describe types of sql statements?

558


Which kind of parameters cannot have a default value in pl sql?

593


How many sql are there?

507


What is right join sql?

530


What is the use of %rowtype?

531