Question

Which of the following queries will return the first 10% of the records in the salary table?

Question options:

select first 10% * from salary order by employee_id asc;

select percent(10) * from salary order by employee_id asc;

select top 10 % * from salary order by employee_id asc;

select top 10 percent * from salary order by employee_id asc;

Answer 1

Ans: select top 10 percent * from salary order by employee_id asc;

Explanation:

The correct syntax for selecting the top x % of the records in any table is:

SELECT TOP x PERCENT *

FROM Table_Name

WHERE condition;

Note : WHERE clause is optional.  

For example, selecting top 30% of the records in STUDENT table is:

SELECT TOP 30 PERCENT * FROM STUDENT;  

And all other options in the question will result in syntax errors.