select max(sal) from emp where rownum = 2;

how to find the second highest salary from emp table?

Question Posted / vinay

Answer Posted / vinay

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Are pl sql variables case sensitive?

1045

Explain aggregate functions are available there in sql?

1003

What are the methods of filing?

935

List the ways to get the count of records in a table?

900

What is a temporal data type?

1045

How many joins can you have in sql?

935

How to display Row Number with Records in Oracle SQL Plus?

1043

Does sql backup shrink transaction log?

977

What is the difference among union, minus and intersect?

1000

What is the difference between the sql*loader and import utilities? : aql loader

1037

Is join an inner join?

963

Do stored procedures prevent sql injection?

966

What is difference sql and mysql?

980

What are the disadvantages of file system?

1262

What is vector point function?

1050