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

hi i want manual testing interview question(3+exp)please tell me

0 Answers  


How can a tester knows that,these testcases are enough for this build or there is no testcases to be written or to stop the testcases now?

3 Answers   VJIL Consulting,


IN software testing i have 3.2 yrs exp in testing. last week i attend the interview at Dell comaputers. interviewer asked me that what are the challenges faced in the project. but i didn't able to answer it properly. Anybody can answer it. Thanks in advance.

0 Answers   DELL,


pls explain perfomence testing and strees testing load testing

2 Answers  


how to test the case with 5 combination and inputs

0 Answers   Infosys,






What type of documents present in Application Design document?

1 Answers   TCS,


What is the difference between User Acceptance Testinga and System Testing?

16 Answers   EDS, InTouch,


What is Bugzilla ?

2 Answers  


how can u map SDLC With STLC

6 Answers   Hewitt,


Should testing be only after build and execution?

1 Answers  


Suppose i want to test an application with in three week, how i will prepare test strategy for this testing.? which testing types should i follow?

7 Answers   TCS, SIRD,


what is the difference between Load,Stress and Volume Testing?

8 Answers   Trigent, DELL,






Categories