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
- 5691 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
What is database design and development?
Explain about the hierarchical model of the database?
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
Write the fastest query to find out how many rows exist in a table?
Explain about relational operator join?
What is dbms and its application?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
What are data modelling techniques?
Explain the role of indexing in databases?
How would you design a database for an online site, which would average a million hits a day?
How is data stored in dbms?
In which table collections errors are stored.
What are the constraints on severity level in raiseerror?
What is data modeling with example?
Explain about relational database management systems?
