Write SQL query to see first 100 recorders from table?

Categories >> Software >> Testing >> Manual Testing
Suggest New Category

Question Posted / rohinid

9 Answers
9707 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Write SQL query to see first 100 recorders from table?..

Answer / rohinid

I think query should be:

select TOP(100) from TABLE_NAME;

Not sure, its correct or not.

Is This Answer Correct ?

11 Yes

2 No

Write SQL query to see first 100 recorders from table?..

Answer / navrattan singh

Select * from emp where rownum<=100

Is This Answer Correct ?

3 Yes

0 No

Write SQL query to see first 100 recorders from table?..

Answer / ammu

SQL server
select top 100 * from table_name;
Oracle
select * from table_name where rownum<=100;
MySQL
select * from table_name limit 100;

Is This Answer Correct ?

2 Yes

0 No

Write SQL query to see first 100 recorders from table?..

Answer / ranjeet verma

select top(100)* from emp

select top 100 * from emp
Select * from emp where rownum<=100
select top 100 percent * from emp

Is This Answer Correct ?

1 Yes

0 No

Write SQL query to see first 100 recorders from table?..

Answer / ammu

Oracle
select * from table_name where rownum<=100;

SQL server
select top 100 * from table_name;

MySQL
select * from table_name limit 100;

Is This Answer Correct ?

0 Yes

0 No

Write SQL query to see first 100 recorders from table?..

Answer / ajay

select TOP 100 from table;

Is This Answer Correct ?

1 Yes

2 No

Write SQL query to see first 100 recorders from table?..

Answer / dfg

select TOP 100 from table;

Is This Answer Correct ?

0 Yes

1 No

Write SQL query to see first 100 recorders from table?..

Answer / shiva ch

Select TOP(100) from emp;

Displayed first 100 columns in emp table

Is This Answer Correct ?

0 Yes

1 No

Write SQL query to see first 100 recorders from table?..

Answer / ashavini patil

Select Top 100* from Table_Name

Is This Answer Correct ?

1 Yes

2 No

Post New Answer