SELECT salary FROM employee a WHERE &n IN (SELECT COUNT(*) FROM emp

how to find the second highest salary from emp table?

Question Posted / mallika

Answer Posted / mallika

SELECT salary FROM employee a
WHERE &n IN (SELECT COUNT(*) FROM employee b
WHERE a.salary <= b.salary)

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is mutating sql table?

1107

What is a trigger word?

1020

What are different types of keys?

1100

What is an oracle stored procedure?

1050

How to write html code in pl sql?

1113

What is a join query?

956

Can we edit a view in sql?

983

What is sql performance tuning?

917

Is truncate ddl or dml?

991

State some properties of relational databases?

1056

What are crud methods?

1029

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1228

Is it possible to create the following trigger: before or after update trigger for each row?

1284

How do you remove duplicate records from a table?

938

What are the different types of constraints?

1177