Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 89985 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / sikindar
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
material view and view disadvantages?
What is the difference between a user and a schema in oracle?
How do I call oracle stored procedures that take no parameters?
What is meant by raw datatype?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Explain the difference between sap and oracle?
Explain the use of record length option in exp command.
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Explain the use of full option in exp command.
What is the data pump export utility?
How to add another datafile to a tablespace?
What is dual table oracle?
What operating systems are supported by oracle database 10g xe?
What is object data modeling?
What are the different windows events activated at runtime ?
