select * from emp where max(sal) where rownow=2

how to get second highest salary in SQL(as/4000

Question Posted / praveen

Answer Posted / praveen

select * from emp where max(sal)
where rownow=2

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the two types of periodical indexes?

987

What is the cause of mutating table error and how can we solve it?

1099

How do I find sql profiler?

992

Can pl sql procedure have a return statement?

1072

what are sequences

1822

How do I create a sql database?

1055

Is nosql faster than sql?

1073

What is sqlite format?

1263

How do I copy a table in sql?

1037

Can procedure in package be overloaded?

1140

Why should I use postgresql?

1068

What is natural join in sql?

1044

Does sql*plus also have a pl/sql engine?

1131

Does sql backup shrink transaction log?

1045

Which tcp/ip port does sql server run?

1068