select min(select top(2)salary from emp)from emp;

how to calcuate the second highest salary of he employee

Question Posted / vivek ghorad

Answer Posted / vivek ghorad

Is This Answer Correct ?

3 Yes

9 No

Please Help Members By Posting Answers For Below Questions

what are date and time functions in mysql? : Sql dba

966

Explain dml and ddl?

969

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3558

How do you rank data in sql?

984

What is index example?

995

what are wild cards used in database for pattern matching ? : Sql dba

1125

What is trigger in pl sql with examples?

1016

How many unique keys can a table have?

1001

What is procedure explain with program?

999

What is %rowtype in pl sql?

980

What is a join query?

941

What is procedure and function?

961

what is a table in a database ? : Sql dba

1026

What is the difference between python and sql?

978

What is dense_rank in sql?

958