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 is Test Strategy and Test Plan..what is the Diff.between those?

2 Answers   Crea,


What is Forward and Backward compatibility? How will you write test cases for compatibility testing?

1 Answers  


.what are the types of recording modes in winrunner 2.what are the three modes of running a test in winrunner 3.what is synchronization point 4.what are the contents present in a test case 5.do we need testing for the project 6.what is code review and code walk through At which phase the testing starts (begin) in the project How do we test Client server applications and a Web applications what is verification and validation what is adhoc testing what is traceability matrix what is base line document what is Test Life Cycle what is regression testing and retesting what is a BUG LIFE CYCLE what is a Bug what are defects what is functionality testing and system testing. a project has to be released in one day but the testing people got that project from the developers half of the day before so what they have to do to complete the testing process. 20 what are severity level and priority levels

1 Answers   Stag Computers,


How to write testcases for unread/read mails for gamil inbox? and what are the types of testing you do on them?

0 Answers   3D PLM,


What is the meaning of incident in testing?

9 Answers   Alcatel, Cambridge,


what is testing management methodologies?? plz help me

2 Answers  


self join query in sql. 15 objective questions. What is equi join and outer join

2 Answers   Bally Technologies,


When do you escalate issues to your Manager?

1 Answers   MTN,


What are the different types of testing u r doing in ur project

3 Answers   Symphony,


what is srs or brs file

7 Answers  


How to prepare web applications use case document.can you send the some sample use case document for web application Project?

0 Answers  


Give me atleast 10 cases of GOOGLE search engine?

7 Answers   Google,


Categories