sql> select * from emp where sal=(select max(sal) from emp);

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

Question Posted / amedela chandra sekhar

sql> select * from emp where sal=(select max(sal) from emp);

chandumba2005@gmail.com

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between mdf and ndf files?

573

How delete a row in sql?

535

what is a table in a database ? : Sql dba

546

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

581

What is a mutating table and a constraining table?

575

What is full join in sql?

526

What is mutating sql table?

612

What does trigger mean in psychology?

537

How many types of cursors supported in pl/sql?

596

Can we insert delete data in view?

547

What is varray in pl sql?

566

What is a file delimiter?

558

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

524

What are the advantages of sql? Explain

651

What is meant by truncate in sql?

528