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
- 5587 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
Explain about relational operator join?
How would you design a database for an online site, which would average a million hits a day?
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?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What is an application role and explain a scenario when you would use one?
How can you fix a poorly performing query?
Explain the cube operator?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Explain the process of the user request and data generating?
Write short notes on manual refreshes.
What are the types of database model?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
What are the main phases of database development?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
