Select salary from (select salary from employees) where rownum <=2;

how to retrieve the top 2 salaried persons from a database?

Question Posted / unknown

Answer Posted / unknown

Select salary from (select salary from employees) where
rownum <=2;

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Write the alter statement to enable all the triggers on the t.students table.

1129

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1127

Is like operator in sql case sensitive?

1031

what is row? : Sql dba

1230

What are triggers and its uses?

1052

What does the hierarchical profiler does?

1065

Can we create clustered index without primary key?

971

Explain architecture of sql server notification services?

1065

What are all types of user defined functions?

1078

What is sql character function?

1092

How do you run a query?

995

What is clause in sql?

1117

What is union?

1178

What is mdf ldf and ndf?

1006

What is benefit of creating memory optimized table?

976