Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 91298 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / premsagar12
select max(sal) from emp where sal<(select max(sal) from emp);
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How will you write a query to get a 5th rank student from a table student_report?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is instant client oracle?
What is difference between truncate and delete?
What are joins, explain all types of joins?
What is a sub query? Describe its types?
How to define an oracle sub procedure?
How to get a create statement for an existing table?
How to assign a tablespace to a users in oracle?
What privilege is needed for a user to create views in oracle?
What are the differences between blob and clob in oracle?
How to use in conditions in oracle?
What is a table in oracle?
How can I get column names from a table in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
