SELECT salary FROM tb_salary ORDER BY salary DESC LIMIT 2,1

how to find the second highest salary from emp table?

Question Posted / tarun

Answer Posted / tarun

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is multiple partition?

968

what is a tablespace? : Sql dba

1053

How global cursor can be declare with dynamic trigger ?

2210

What do you understand by pl/sql records?

1018

What is %rowtype in pl sql?

991

How do I start sql profiler?

997

What is identity column in sql server?

1049

What are different types of functions in sql?

1005

How many sql commands are there?

1115

How do I find duplicates in two columns?

1169

what is the difference between union and union all? : Sql dba

1020

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1120

What is not null in sql?

1058

What is a record in pl/sql?

1148

What is lookup table in sql?

1049