if u want select the second highest salary from the emp table then u

how to find the first two highest salaries in deptno in emp
table

Question Posted / santhosh kandula

2 Answers
5598 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

Please Help Members By Posting Answers For Below Questions

Explain about the hierarchical model of the database?

1124

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?

1069

In which database can extended stored procedures be added?

911

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? Belgian Waffles $5.95 two of our famous Belgian Waffles with plenty of real maple syrup 650 Strawberry Belgian Waffles $7.95 light Belgian waffles covered with strawberries and whipped cream 900 Berry-Berry Belgian Waffles $8.95 light Belgian waffles covered with an assortment of fresh berries and whipped cream 900 French Toast $4.50 thick slices made from our homemade sourdough bread 600 Homestyle Breakfast $6.95 two eggs, bacon or sausage, toast, and our ever-popular hash browns 950

2150

How can you fix a poorly performing query?

1198

What is DB Development software?

2082

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

972

Explain the process of the user request and data generating?

1103

Explain about a primary key?

992

How to read and create .LDC data files which are used by linguatic dictionary.

2539

Explain about network model?

1010

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?

1013

Explain about the relational database?

1086

What are the three types of database design?

1029

explain detail about ftp in datastage?

2252