write a query to display to 10 max record from the employee table?

Categories >> Software >> Data Warehouse >> Cognos
Suggest New Category

write a query to display to 10 max record from the employee
table?

Question Posted / sekhar

7 Answers
12096 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write a query to display to 10 max record from the employee table?..

Answer / madhoo

You are question is not clear.....you need decide based on
which column you want first 10 records.....

if you work on Salary column this is the query .......

select distinct sal from emp a
where (select count(*) from emp b where a.sal<b.sal)<=10
order by sal desc
/

Any queries on Sql please feel free to ask me i am very
interest in it......

Is This Answer Correct ?

7 Yes

0 No

write a query to display to 10 max record from the employee table?..

Answer / srinu

select * from(select rownum r,emp.*from emp order by sal
desc) where r<=10;

Is This Answer Correct ?

6 Yes

2 No

write a query to display to 10 max record from the employee table?..

Answer / don

we can create a list report and sort the field which we
need the top 10 of in an descending order and before
running the report set rows per page to 10

Is This Answer Correct ?

2 Yes

0 No

write a query to display to 10 max record from the employee table?..

Answer / m m naidu

To display first 10 records we can write the query as
select * from(select * from emp order by ename desc) where
ronum<=10;

Is This Answer Correct ?

7 Yes

6 No

write a query to display to 10 max record from the employee table?..

Answer / lakhwinder singh

Query for display the top 10 records from the table(tbl1)

select top 10 * from tbl1

Is This Answer Correct ?

4 Yes

3 No

write a query to display to 10 max record from the employee table?..

Answer / sathish

select * from employee
limit 10

Is This Answer Correct ?

1 Yes

3 No

write a query to display to 10 max record from the employee table?..

Answer / richard

Select Max(Count=10) from emp a

Is This Answer Correct ?

3 Yes

8 No

Post New Answer