SELECT TOP (3)with ties empsalry FROM empsalr order by emp

a query to select maxmun 3 salaries of employee table

Question Posted / kumari

12 Answers
20709 Views
IBM, Polaris, I also Faced
E-Mail Answers

Answer Posted / kumari

SELECT TOP (3)with ties empsalry
FROM empsalr

order by empsalry desc;

Is This Answer Correct ?

1 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Difference between the “verify” and “feedback” command?

1426

How to create an oracle database?

1100

What is set verify off in oracle?

1156

What is the database name in oracle?

1078

How to convert a string to a date in oracle database?

1093

How to experiment a data lock in oracle?

1108

How to convert characters to times in oracle?

1070

What privilege is needed for a user to query tables in another schema?

1030

What do database buffers contain?

1082

Why oracle is used?

1106

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1437

What is object data modeling?

1016

How to convert characters to numbers in oracle?

1112

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2090

What is not equal to in oracle?

1047