Interested to Buy Any Domain ? << Click Here >> for more details...
Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
- 10 Answers
- 15059 Views
- Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon, I also Faced
- E-Mail Answers
Answer Posted / amitkumar
Select TOP 1 salary from (select Distinct TOP 2 salary from
employee orderby salary desc)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is the relation of a user account and a schema in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to start your 10g xe server?
Explain table?
What is the difference between 10g OEM and 11g OEM?
How to manage transaction isolation level?
What is a data dictionary and how can it be created?
How to delete a column in an existing table?
How to create id with auto_increment on oracle?
What is BBED in Oracle?
How to display employee records who gets more salary than the average salary in the department?
What are the execution control statements in oracle?
What are the oracle built-in data types?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
In oracle there is column command, how will you explain that?
