write a query to Find the Maximun second value in table?
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
What do you mean by Correlated subquery in database?
Which is better saving files in database or in file system?
what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?
Which is fastest database?
Which is best database?
Which database is good for large data?
What is local database?
Which is the best database?
Which database is best for storing images?
What is data model and types?
Which database is best for large data?
What is limit in dbms?
What is the best free database software?
What is distributed queries?
Is it possible to declare or create a cursor for update of table? If no tell me why?