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

How do you go about testing a project?

0 Answers  


Hello Friends, I m working as tester in a company, i have 1.5 yrs of exp., in my company we used manual testing Technique & i wants to give The ISTQB Certified Tester-Foundation Level certificate Exam. Can any one tell me the next date of the exam.? If anyboady have questions papers OR any material then pls. frwd me on my id : preet45p@yahoo.com Thanks in advanced.

3 Answers  


who prepares the use cases?

4 Answers  


explain functionality testing and functional testing and give example who do thattype of testing

1 Answers   Wipro,


what is smoke testing?

9 Answers  






Which was the most interesting bug you found.

0 Answers  


When to do Black box testing?

0 Answers  


Please tell me some test cases for GOOGLE.COM

1 Answers  


Contents in Tracebility matrix?

14 Answers   JVS, NIIT, TCS,


How to conduct Regression Testing Manually?

9 Answers   FIC,


WHAT IS SECURITY TESTING.HOW TO DO SECURITY TESTING.IS THERE ANY FRAMEWORK AVAILABLE

2 Answers  


Differentiate verification and validation?

0 Answers  


Categories