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

Diff between static and dynamic review?

3 Answers   Softdel,


hai suppose if i want to delete cookie of a particular web site.is it possible if it is possible how? pls. tell me

1 Answers  


what the diff b/w Smoke Testing and Santy Testing?

10 Answers   Cap Gemini, Financial Technologies,


1:differenciate between functional regression and gui test cases 2:for a given requirement how to write test case and prepare test data with example like for monster.com front page what testing techniques are used at what requirments see monster page 3: can we test without front end application and can we perform testing without back end application 4:all possible questions asked on bugzilla plz answer as soon

1 Answers  


Web application is having a client and a client-server application aslo have a client. Then what is the technical difference between thease two clients? can any body expain?

4 Answers  






In which phase the GUI Testing will be held on V model?

1 Answers  


How to test Reports manually?

2 Answers  


what are the type of test strategy

3 Answers  


Explain Bug Life cycle What is integration testing and regression testing What is verification and validation How does winrunner recognizes the project which is in custom build What is expert view and tree view How does QTP identifies the project What is the difference between Winrunner and QTP What is Test Director and which version of test director your are using in your project What is a test plans what are the contents present in a test plan What is the risk of testing a project

4 Answers   Mphasis,


difference between sretagic test plan & test plan?

2 Answers   IBM,


What methodolgies you used to develop test Cases?

3 Answers  


what is seviority and priority, and who will assign seviority and priority and High seviority and high priority , High seviority and Low priority and Low seviority and High priority and Low seviority and Low priority-- pls, if you know really give the answer,because in every interview they are asking plssssssss

8 Answers   Deloitte, QuinStreet,


Categories