how to find the second highest salary from emp table?

Answer Posted / masthan

select *from emp where sal<selct *from emp where<select *from emp

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are left and right joins the same?

536


What are the disadvantages of file system?

619


Where not exists in sql?

504


What is sql*loader and what is it used for?

582


What is left inner join in sql?

519






Is a foreign key always unique?

536


What is online transaction processing (oltp)?

605


How do I find duplicates in the same column?

549


what are the 'mysql' command line options? : Sql dba

561


what are all types of user defined functions? : Sql dba

550


how many ways to get the current time? : Sql dba

530


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

539


How to raise user-defined exception with custom sqlerrm ?

682


how to calculate expressions with sql statements? : Sql dba

532


How to display the current date in sql?

603