SQL> select emp_sal from (select emp_sal from nitin order by emp

how to find the second highest salary from emp table?

Question Posted / nitin

Answer Posted / nitin

SQL> select emp_sal from (select emp_sal from nitin order
by emp_sal desc) group by rownum,emp_sal
having rownum=2;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how can we destroy the cookie? : Sql dba

1082

how would concatenate strings in mysql? : Sql dba

1143

How to process query result in pl/sql?

1203

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1126

What is a dirty read sql?

1247

How to rename a column in the output of sql query?

1131

what is uncommittable transactions? : Transact sql

1038

Does pl sql work in mysql?

1035

how is myisam table stored? : Sql dba

1099

How do I filter in sql profiler?

1055

Explain dml and ddl?

1059

Can we enter data in a table in design view?

1013

What is sql scripting?

1196

How do I order columns in sql?

1074

explain primary keys and auto increment fields in mysql : sql dba

1017