find out the second highest salary?
- 55 Answers
- 76101 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / mukesh
Second highest Value
select max(user_id) from users
where user_id < (select max (user_id) from users)
Mukesh Narayan SIngh
09873595976
mukeshnsingh22@gmail.com
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How a tablespace is related to data files?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How many types of tables are there in oracle?
How do we create privileges in oracle?
what are archived logs?
What is the maximum number of triggers that can be applied to a single table?
What do you mean by a tablespace?
How to create a stored procedure in oracle?
What happens to the indexes if a table is recovered?
How can we create the complete backup of data in the oracle.
What do you mean by merge in oracle?
What is oracle update statement with inner join ?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
does the query needs a hint to access a materialized view?
How to get a list of all background sessions in the database?
