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 literals in sql server?

1174

How many joins in sql?

1016

How do I edit a trigger in sql developer?

1000

what is sql server agent? : Sql dba

1110

How to look at the current sql*plus system settings?

1152

What is localdb mssqllocaldb?

1070

Can a table contain multiple primary key’s?

1099

Cite the differences between execution of triggers and stored procedures?

1081

Does view store data in sql?

969

Enlist the advantages of sql.

1002

How do I delete a trigger?

968

What is a loop in sql?

989

What is the difference between an inner join and an outer join?

1027

how to select unique records from a table? : Sql dba

1115

What is where clause in sql?

1043