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

How many types of primary keys are there?

1038

What are the types of optimization?

961

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1234

How can I see all tables in sql?

1077

Write a sql query to find the names of employees that begin with ‘a’?

1015

What is execution plan in sql?

1046

Is pl sql a programming language?

991

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1138

What is structural independence and why is it important?

1031

Explain sql data types?

1100

Which is faster view or stored procedure?

946

What is the starting oracle error number? What is meant by forward declaration in functions?

994

Why do we need cursors in pl sql?

1081

what does the t-sql command ident_incr does? : Transact sql

1077

Why is sql better than hql?

992