how to find the first two highest salaries in deptno in emp
table
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 a primary key?
How can you fix a poorly performing query?
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 detail about ftp in datastage?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Explain the role of indexing in databases?
How to customize error conditions.
What is an application role and explain a scenario when you would use one?
How to use online Backups?
Explain about xml databases?
Which data type cannot be used as a parameter in a udf?
How you can make a parameterized view?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Who are end users in dbms?
Why does this query return 0?