select max(sal) from emp where sal not in (select max(sal) from emp)

write a query to Find the Maximun second value in table?

Question Posted / kavita

5 Answers
6861 Views
I also Faced
E-Mail Answers

Answer Posted / kavita

select max(sal) from emp where sal not in (select max(sal)
from emp)

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is drivermanager getconnection?

988

Why do we study dbms?

890

What is a relation schema?

928

What is tuple and attribute?

882

What is a checkpoint in dbms and when does it occur?

944

What do you understand by join?

996

What is the difference between hashed file stage and sequential file stage in relates to datastage server?

1047

Explain what are the two types of oltp?

969

What is the difference between multiload and fastload interms of performance?

911

Explain all codd's rules for relational database system?

899

Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.

1086

For each user who needs access, the DBA creates an account in which database?

1143

Can you explain the select into statement?

985

Define database.

958

Does any body has ORACLE Certification latest Dumps on 1) Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet Application Developer, 4) OCA, 5) OCP 8i to 10g DBA Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if any body has please send it to taruni_2k8@yahoo.com

2623