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 use of term?

1062

What is the difference among union, minus and intersect?

1000

What are records give examples?

1002

Show the two pl/sql cursor exceptions.

1191

what is acid property in database? : Sql dba

1029

What is substitution variable?

1050

What is a recursive stored procedure?

1179

Can we create foreign key without primary key?

983

Is merge a dml statement?

977

What are the topics in pl sql?

970

Why is sql better than hql?

985

What is a clob in sql?

1017

Explain isolation levels. : Transact sql

1068

What is not equal in sql?

1116

Is sql difficult?

1152