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
- 14823 Views
- I also Faced
- E-Mail Answers
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
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
How can I detect whether a given connection is blocked?
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?
Write the fastest query to find out how many rows exist in a table?
What is an application role and explain a scenario when you would use one?
What is normalization? Explain different levels of normalization?
explain detail about ftp in datastage?
What are the 18 schemas?
Explain about normal forms?
Explain the role of indexing in databases?
Explain about xml databases?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
State the acid rules?
Who are naive users?
