write a query to Find the Maximun second value in table?
- 5 Answers
- 5873 Views
- I also Faced
- E-Mail Answers
Answer Posted / tulasi
select * from emp x where 2=(select count(distinct sal)
from emp y where x.sal<=y.sal);
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
I want to export the data date to date from oracle database then what can i do?
What do you understand by query optimization?
What do you understand by fragmentation?
What is dbms pdf?
Who is end user in database?
What are different types of joins in the sql?
Mention a query to add email validation to your database
Explain openquery function and openrowset function?
Explain atomicity and aggregation?
Enlist the advantages of dbms.
What are the main components of a database system?
Mention the differences between trigger and stored procedures
What are the examples of database?
Explain the classification of Database Management System?
what is storage manager?
