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
- 14825 Views
- I also Faced
- E-Mail Answers
Answer Posted / sowjanya
Select * from emp where sal=(select Max(sal) from emp where
sal<(select Max(Sal) from emp)
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is dbms and its application?
How to customize error conditions.
State the acid rules?
What is normalization? Explain different levels of normalization?
What are the 18 schemas?
What is a database development?
How would you design a database for an online site, which would average a million hits a day?
explain detail about ftp in datastage?
Explain about query and reporting.
Write short notes on manual refreshes.
Who are naive users?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
Explain about relational database management systems?
Explain the process of the user request and data generating?
Explain the rollup operator?
