how to find the first two highest salaries in deptno in emp
Answers were Sorted based on User's Feedback
Answer / 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|
Explain about post-relational databases?
How to read and create .LDC data files which are used by linguatic dictionary.
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 generate OIDS
Define candidate key, alternate key, composite key?
In which database can extended stored procedures be added?
what is the use of foreginkey
Write short notes on manual refreshes.
Write the difference between case version and decode version.
Explain about relational operator join?
explain detail about ftp in datastage?
What are triggers? How many triggers you can have on a table?