Write SQL query to see first 100 recorders from table?




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



More Manual Testing Interview Questions

I through 1st round of interview in manual testing, now in the 2nd round i have written test and oral, what to expect in written test & what is the basic salary can i expect? i have only 1 yr experience and took break for more than 5 years.

2 Answers   Chetu India,


When should testing be stopped?

24 Answers   GE,


Enlist types of testing performed for any window in sequence?

1 Answers  


wht is need for testing?why testing is neccsary?why testing is done?

6 Answers   SoftSmith, mPortal,


What is the difference between internal reviews and peer reviews?

2 Answers  






how to write integrated test case for an ATM?

4 Answers   IndiumSoft,


what is Recovery testing?

3 Answers   Crea,


What is the difference between Quality Plan and Test Plan Anybody can give answer..Thanks in advance...

5 Answers   Symphony,


3. What Web sites do you use to learn about Web accessibility?How often do you use them?

0 Answers  


if the object is identified by QTP & also virtual object wizard then which object will added to object repository

4 Answers   Tech Mahindra,


which environment you like to work?

3 Answers  


What is PET Model? Overview of Pet model and benefits of it?

1 Answers   HCL,






Categories