how to find the second highest salary from emp table?

Answer Posted / jude

first find first maximum
then easy to find second maximum

Is This Answer Correct ?    98 Yes 330 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does inner join return duplicate rows?

522


What is sql used for?

647


How can check sql version from command line?

536


what are the different functions in sorting an array? : Sql dba

583


Can we connect to postgresql using sql developer?

490






What is sql server and ase?

543


Is it possible for a table to have more than one foreign key?

582


How do you explain an index number?

539


What is the benefit of foreign key?

528


Why truncate is used in sql?

533


How to rename a column in the output of sql query?

539


What is pl sql code?

593


Why should I use postgresql?

566


Can we use update in sql function?

588


What are two statement types in sql?

540