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

Answer Posted / pree

Select name,salary from Employee where salary in(select max
(salary)
from Employee );

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pl sql in dbms?

508


What are different types of statements supported by sql?

610


What are the types of sql commands?

554


Which data type is a composite type?

534


Can I join the same table twice?

527






Why is %isopen always false for an implicit cursor?

570


Why join is faster than subquery?

603


What are the different tcl commands in sql?

624


What are the three forms of normalization?

536


What is trigger in sql and its types?

538


What is a data manipulation language?

573


How do I count duplicates in sql?

552


Is it possible to sort a column using a column alias?

609


What is data control language (dcl)?

601


What is scalar function?

569