Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 64139 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
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 |
What is Water Mark in Oracle?
how to handle exceptions in post production
What is data block in Oracle?
Is there a combination of "like" and "in" in sql?
what is port in oracle? how is it related to database application.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is an oracle and why it is used?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
How to find the date and time of last updated table?
what is pragma?
Oracle General 
