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

Is it good to save image in database?

994

Explain the Normalized Relations?

2679

Explain the different types of database keys?

961

What do you understand by correlated subqueries in dbms?

945

What is pcbs (program communication blocks)?

991

Differentiate between ‘cluster’ and ‘non-cluster’ index.

931

What do you mean by e-r model & object-oriented model?

925

What is the use of database management system?

964

What's the difference between delete and truncate ?

1040

What do you mean by entity type extension?

1044

What is data management process?

928

why an information gap exists in most organizations.

987

What is system catalog or catalog relation?

1066

Which two statements are true about a foreign key?

955

What is use of foreign key?

855