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

Explain ddl interpreter?

1197

What is end users in dbms?

966

why an information gap exists in most organizations.

1021

What are the types of tables in database?

993

How does distributed database work?

981

Is the internet a database?

946

What are stand-alone procedures?

961

What is different keys in dbms?

945

What is buffer manager?

925

How to handle data if f table are more than one and each table contain thousands of entries?

2049

What is a database in a website?

1064

Where is data stored in a database?

1007

Explain the term ‘relations’?

892

What is blob database?

944

Explain the use of assign statement in progress database?

906