select max(sal) from Table where sal not in(select max(sal) from Table);

How to Select second Maximum salary in a Table ?

Question Posted / guest

Answer Posted / guest

select max(sal) from Table
where sal not in(select max(sal) from Table);

Is This Answer Correct ?

20 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is difference between truncate and delete?

1042

How to load a large xml file?

1058

What is blob data type in oracle?

1123

Design database draw er diagram for a certain scenario ?

4579

How to drop a tablespace?

1048

How to Truncate Table in Oracle

1158

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

How to update a table row with a record?

1011

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4174

What is a snapshot in oracle database?

1025

What are data pump export and import modes?

1071

How to delete a column in an existing table in oracle?

1073

What is oracle database client?

1035

What is a subquery?

1125

Which environment variables are absolutely critical in order to run the OUI?

2120