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

how to find the second highest salary from emp table?

Question Posted / ved

Answer Posted / ved

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

Is This Answer Correct ?

12 Yes

20 No

Please Help Members By Posting Answers For Below Questions

What is pl sql variable?

981

What is the difference between row level and statement level trigger?

1019

How do you run a query?

989

Is truncate ddl or dml?

991

What is difference between stored function and application function?

1195

Which one is better subquery or joins?

1058

What is the difference between stored procedure and view?

1016

What is the maximum database size for sql express?

1020

what is offset-fetch filter in tsql? : Transact sql

944

Can delete statement be rollbacked?

984

What are user defined functions?

1012

what does myisamchk do? : Sql dba

1011

What do you mean by field in sql?

1076

Does truncate require commit?

967

how do you tune the slow running queries in oracle db , explain the methodology

2726