Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to Find the Maximun second value in table?
- 5 Answers
- 6802 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
What is a relation schema?
What is indexing in database with example?
What is meant by a database?
What are the types of model?
What is data modelling concepts?
What is sonicmq?
Define database.
Have you written applications to retrieve stored images in a table?
What are the features of database language?
Is the internet a database?
What is the purpose of sql?
What is database management used for?
What do you mean by entity type extension?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
What is the main purpose of database?
