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
- 14205 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
In which database can extended stored procedures be added?
Explain about normal forms?
Can an extended stored procedure be called from inside a user-defined function?
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 the role of indexing in databases?
Explain the process of the user request and data generating?
What is an application role and explain a scenario when you would use one?
What is normalization? Explain different levels of normalization?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Explain about network model?
How can you log an error to the server event log from a stored procedure?
Explain about a primary key?
What are the constraints on severity level in raiseerror?
What is the physical representation for a many-to-many relationship?
State the acid rules?
