Query to get max and second max in oracle in one query ?
Answers were Sorted based on User's Feedback
Answer / braulio
-- that's it
select * from
(select max(salary) from salary)
where rownum = 2
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / bhamidipati srinivas
select (select max(gross) from employee_dtls),(select max
(gross) as nextmaximum
from employee_dtls where gross<(select max(gross) from
employee_dtls)) from dual
Is This Answer Correct ? | 2 Yes | 4 No |
Answer / sdfsfsdf
to install .sh files(.exe files)in linux.copy the file
inusr.
open terminal go to usr and type bash ./follwed by file name
(can use tab key)
here.
to unistall java in linux we can use rm command
Is This Answer Correct ? | 1 Yes | 4 No |
Answer / naveen
select sal from employee where sal >= (select max(sal) from
employee where sal not in (select max(sal) from employee))
Is This Answer Correct ? | 7 Yes | 14 No |
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
How do we switch from init.ora file to asp file?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
definition of cluster and non-clustered index?
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
Can we commit inside a function in oracle?
Is oracle a language?
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
What does a Control file Contain ?
what are the default admin accounts in Oracle 10g ?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??