find out the second highest salary?
Answer Posted / karthikeyan
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
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is raw datatype in oracle?
What happens if the update subquery returns multiple rows?
How do you tell what your machine name is and what is its IP address?
What are the major difference between truncate and delete?
How to define an explicit cursor in oracle?
How do I call oracle stored procedures that take no parameters?
does the query needs a hint to access a materialized view?
What is instant client oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How many anonymous blocks can be defined?
How to use "for" statements in oracle?
How much memory your 10g xe server is using?
how to clone 9i Database on to 10g Database.