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 order by sal desc )
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the 18 schemas?
Explain what a database is?
How to read and create .LDC data files which are used by linguatic dictionary.
What is database design and development?
Write short notes on manual refreshes.
What are the constraints on severity level in raiseerror?
How to customize error conditions.
What is normalization? Explain different levels of normalization?
How you can make a parameterized view?
What is the maximum length of an extended property?
Explain about the relational database?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
fact table and dimension table containg one to many relationship or many to one relastionship
Explain about a primary key?
What is DB Development software?