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
Which four data types cannot be used as a return type from a user-defined function?
What is database design and development?
Explain about the relational database?
What is dbms explain in brief?
Explain the role of indexing in databases?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
What is data modeling with example?
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?
Explain about query and reporting.
What is an application role and explain a scenario when you would use one?
What is normalization? Explain different levels of normalization?
Explain about normal forms?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Write the fastest query to find out how many rows exist in a table?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?