find out the third highest salary?
Answer Posted / punit chauhan
select * from emp where sal<(select max(sal) from emp
where sal<(select max(sal) from emp))
punit chauhan
iMS NOIDA
doing MCA
Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Define oracle database
Explain the use of parfile option in exp command.
> 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?
How to define a data source name (dsn) in odbc manager?
How index is implemented in oracle database?
What is a subquery in oracle?
Explain the use of rows option in exp command.
What do you mean by merge in oracle and how can you merge two tables?
What is materialized view in Oracle?
What exactly do quotation marks around the table name do?
How to delete all rows a table in oracle?
How to assign a tablespace to a users in oracle?
Explain the difference between a procedure and a function?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.