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

a query to select maxmun 3 salaries of employee table

Question Posted / kumari

Answer Posted / kumari

SELECT TOP (3)with ties empsalry
FROM empsalr

order by empsalry desc;

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to shutdown your 10g xe server?

1156

How oracle handles dead locks?

1078

How do I call oracle stored procedures that take no parameters?

1128

Who developed oracle & when?

1014

How to create an initialization parameter file?

1062

How to drop an index?

970

How to empty your oracle recycle bin?

1034

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2156

What is the difference between sharding and partitioning?

996

How to initialize variables with default values?

1253

Explain integrity constraints?

1114

What is a database table in oracle?

1029

Explain about integrity constraint?

1136

What is hash cluster in oracle?

1181

Explain about functional dependency and its relation with table design?

1022