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

Answer Posted / pradeep sahoo

Select * from Employee where sal = (select max(sal) frpm
Employee)

Is This Answer Correct ?    25 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many databases can sql express handle?

526


define sql insert statement ? : Sql dba

546


how can we optimize or increase the speed of a mysql select query? : Sql dba

502


What are the different schemas objects that can be created using pl/sql?

520


What is informix sql?

533






Is sql a dbms?

526


What is program debugging?

554


How do you respond to dementia behavior?

527


Why query optimization is needed?

511


Explain the working of primary key?

602


Is pl sql useful?

537


What is the difference between partitioning and sharding?

523


If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3544


how to concatenate two character strings? : Sql dba

544


What is pl sql in dbms?

501