SELECT MIN(sal) FROM (SELECT sal FROM emp ORDER BY sal DESC LIMIT 2) AS a ;

how to find the second highest salary from emp table?

Question Posted / tanmoy

Answer Posted / tanmoy

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sql performance tuning?

921

Why is theta join required?

1146

what are enums used for in mysql? : Sql dba

1170

How can you select unique records from a table?

1079

What is the function that is used to transfer a pl/sql table log to a database table?

1023

Is sql better than excel?

1156

Is primary key clustered or nonclustered?

1021

what is a primary key? : Sql dba

1034

How do I run a sql script?

1150

What is synchronized subquery?

1170

What is pl sql code?

1056

What is substitution variable in pl sql?

1046

Can we create table in function?

965

Are pl sql variables case sensitive?

1050

What are inbuilt functions in sql?

1065