select * from emp order by sal desc limit 1,1

how to find the second highest salary from emp table?

Question Posted / dinesh

Answer Posted / dinesh

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is pl sql in dbms?

949

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

1147

Is null operator in sql?

1029

who introduced sql?

1013

What is sql*plus?

1072

how to rename an existing table in mysql? : Sql dba

1060

How do I kill a query in postgresql?

1110

What is difference between nchar and nvarchar?

1024

Is time a data type in sql?

901

Is truncate ddl or dml?

991

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1010

Does sql full backup truncate logs?

1014

What is sql resultset?

982

Why are sql stored procedures used?

1053

What is pls_integer in pl sql?

1103