select sal from emp where rownum=2 order by sal desc;

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / varun

Answer Posted / varun

Is This Answer Correct ?

6 Yes

19 No

Please Help Members By Posting Answers For Below Questions

What are the different types of functions in sql?

1099

What is a file delimiter?

1164

describe transaction-safe table types in mysql : sql dba

1063

What is data control language?

1034

Can you have more than one key in a database?

994

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1116

how to include comments in sql statements? : Sql dba

999

what is 'mysqlcheck'? : Sql dba

1067

Is mariadb nosql?

1093

What is the largest value that can be stored in a byte data field?

1060

What is the use of double ampersand (&&) in sql queries? Give an example

1189

Can a select statement fire a trigger?

1211

What is a sql statement?

1018

What is rowtype?

1081

Explain what is a database?

1136