Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the first two highest salaries in deptno in emp
table
- 2 Answers
- 5488 Views
- I also Faced
- E-Mail Answers
Answer Posted / santhosh kandula
if u want select the second highest salary from the emp
table then u have to write query as
select max(salary) from emp where
salary < ( select max(salary) from emp )
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
In which table collections errors are stored.
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
What is dbms explain in brief?
Explain about relational operator join?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
How to combine two function together?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Explain about query and reporting.
What is DB Development software?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Explain about the storage and physical database design?
How to use timestamp datatypes
Explain about network model?
In which database can extended stored procedures be added?
