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

Why we use cross join?

999

What is difference between db2 and sql?

1046

Which function is used to return remainder in a division operator in sql?

1196

How do sql triggers work?

1090

How do you delete duplicates in sql query using rowid?

989

What is pl sql block in dbms?

1055

Explain what is sql*plus?

1196

Can we rollback delete command?

1037

How do you truncate?

954

What is informix sql?

1029

Mention what does the hierarchical profiler does?

1138

how to convert numeric values to character strings? : Sql dba

1157

What operators deal with null?

1154

What is asqueryable?

1035

Is trigger a stored procedure?

982