Given an employee table, how would you find out the second
highest salary?
Answer Posted / mithilesh mishra
Select Max(sal) from emp where sal not in (select max(sal)
from emp)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the key features of dbms?
Explain what a database is?
What is normalization? Explain different levels of normalization?
In which table collections errors are stored.
What are the three basic rules which are to be followed for the relational model of the database?
Explain about the storage and physical database design?
What is the physical representation for a many-to-many relationship?
How you can make a parameterized view?
What is an application role and explain a scenario when you would use one?
What is a database development?
How to generate OIDS
Explain about relational database management systems?
How to combine two function together?
Explain about post-relational databases?
How can you log an error to the server event log from a stored procedure?