SELECT filedname FROM tablename ORDER BY fieldname DESC LIMIT 2 , 1

how to find the second highest salary from emp table?

Question Posted / pankaj kumar

Answer Posted / pankaj kumar

SELECT filedname
FROM tablename
ORDER BY fieldname DESC
LIMIT 2 , 1

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the cause of mutating table error and how can we solve it?

994

What are the topics in pl sql?

932

what is a relationship and what are they? : Sql dba

1027

What is a temporal table?

882

What do you understand by case manipulation functions?

954

What are the advantages of indexing?

929

How do I view tables in sql developer?

886

How to prepare for oracle pl sql certification?

1012

What is join view in sql?

898

how many ways we can we find the current date using mysql? : Sql dba

1038

What is procedure in pl sql?

980

What are the different types of tables in sql?

931

Write a query to display the current date in sql?

969

What is user in sql?

970

What do you mean by table in sql?

940