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
Which database is faster?
Mention how deadlock can be resolved?
Define union all operator and union.
What is data example?
What is field in database give an example?
What is the main purpose of a database?
How do I create a database in access 2010?
How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?
What is database normalization? Explain types of it.
When should you consider denormalization?
How to prevent firebird.log file from filling up the disk partition?
What is snow flake schema design in database? What's the difference between star and snow flake schema?
What are the advantages of rdbms?
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
What is meant by database management system?