Interested to Buy Any Domain ? << Click Here >> for more details...
Given an employee table, how would you find out the second
highest salary?
- 9 Answers
- 14567 Views
- I also Faced
- E-Mail Answers
Answer Posted / balindra sahani
select max(sal) from emp
where sal not in (select max(sal) from emp )
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain about the storage and physical database design?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What is the physical representation for a many-to-many relationship?
Who are naive users?
explain detail about ftp in datastage?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
I have a few records all are same structures data, I want to store data in multiple targets how
Explain about normal forms?
What is normalization? Explain different levels of normalization?
How would you design a database for an online site, which would average a million hits a day?
What is data modeling with example?
What are the types of database model?
What is dbms explain in brief?
How is data stored in dbms?
Explain about the database management systems.
