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

What are the advantage of using V models?

5 Answers   Persistent,


What features of sqlserver is generally used in database testing

3 Answers   Mastek,


Explain me software life cycle and SDLC

3 Answers  


i have 1.6 years exp .but i wish to learn QTP .so how can proceed for that .shall i do any course for that or self study.what is the market situation for QTP??

2 Answers  


How to test login page or web login page? are they difference?

1 Answers  






Hi, Below is a question on white box testing. Kindly help me in answering it. How many test cases are needed to obtain 100% branch coverage. This question was asked in ISTQB foudation level exam - Dec21 2008. Read(A,C) If(A<10) then Print A; Endif If(C>100) then Print C is greater then A else if(C<100) then print only C Endif else Options - a. 4 b. 3 c. 2 d. 1 Kindly answer with explanation so that it would be easy to understand

6 Answers   ISTQB,


1.what is test metries ?

2 Answers  


Factors effecting Testing of Web Applications?

1 Answers   Crea,


How load testing is different from regression testing?

2 Answers   Crea,


What kind of interview questions can I expect for an entry level(2 years of exp) software testing position. I am attending for the first interview and bit nervous what to prepare and how to prepare.the company I applied is a product(anti virus software) based company. so what kind of questions can I expect .please help me for preparing .

2 Answers  


If u need to get stressed & work more than then timing. How comfortable u r. If asked to work on weekends

3 Answers   Siemens,


How to report Negative Test Cases? Do we need to insert any new column in the Test Case Document for Negative Test Cases seperately? I'm very much confused. Please answer this question!!!

5 Answers   Reliance, Ciena,






Categories