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 detail about ftp in datastage?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
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
State the acid rules?
What are the 18 schemas?
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
How you can make a parameterized view?
Explain what a database is?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Write the fastest query to find out how many rows exist in a table?
What are data modelling techniques?
Explain about normal forms?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Explain about query and reporting.