Given an employee table, how would you find out the second
highest salary?
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
What are the types of database model?
What is an application role and explain a scenario when you would use one?
I have a few records all are same structures data, I want to store data in multiple targets how
How is data stored in dbms?
Explain about query and reporting.
Write the fastest query to find out how many rows exist in a table?
Explain about the relational database?
What is a database development?
How would you design a database for an online site, which would average a million hits a day?
How to read and create .LDC data files which are used by linguatic dictionary.
How long can an error message be in raiseerror function?
Explain about normal forms?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
What is normalization? Explain different levels of normalization?
What is data modeling with example?