you can use following query select max(sal) from emp where sal<(select

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

Question Posted / ruchi

Answer Posted / ruchi

you can use following query
select max(sal) from emp where sal<(select max(sal) from
emp);

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Why are databases so important?

946

What is concept of dbms?

914

How do you create a database?

914

What are service-specific middleware?

997

How do you call a stored procedure from jdbc?

942

Can we linked SharePoint to a SQL databasebe?

1103

How many types of database language exist?

1043

What is a foreign key constraint?

1018

What is hot backup (in case of oracle)?

928

what are the different integrity rules present in the dbms?

982

What is the best way to determine whether firebird server is running?

1069

What are the various types of relationships in database? Define them.

895

What is procedure in dbms?

890

Is database a storage?

896

What is advantages of progress actional?

919