Write SQL query to see first 100 recorders from table?




Answer Posted / 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






Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi every one can you send me ISTQB Course material on my Email id deeptimundra997@gmail.com

954


Why do we need different environments and different data? What is the other name for environment? Justify your explanation ? real time experts pls xplain?

1668


Different types of design diagrams that supports to write test cases ?

1054


how will you test a wine filled bottle along with 100 glasses

1126


What is test out put?

891






what is difference between win 98 and win 2000 poertating system?which is better one?

1004


Anyone tell me the test cases of Shopping Favorite

791


Please can any one tell me 1).Types of reports 2).Types of Meetings.

686


What is function points??????

805


If anyone have attended interview with deloitte for the post of senior manual test engineer. Please share the interview process and the questions asked. How to prepare for the interview. Thanks in advance

3704


What is mean by incident logging system ?

1204


Any one please can u tell me what is composer? An interviewer asked me do u have experience in Composer? its urgent.

840


What are joins and subjoins in the data bases what is data driven testing what is verification and validation What is Quality Assurance (QA) and Quality Control (QC) Is Verification is related to QA and Validation is related to QC ? which type of model you follow basically in your project what is a use case How to test a Bike how to test a Lift (Elevator). which configuration Management tool do you use which Bug tracking tool do you use explain Bug life cycle what is Regression testing what is ALPHA testing ans BETA testing What types of testings comes under Non functional testing what is TEST DIRECTOR what is CMM and CMM i whar are Expressions in Winrunner What is a Compile module Is it Necessary to open the tool first or the application first after getting a bug what will you do if you add a new object or a new module for the existing application then how will you test the application which Defect tracking tool do you use what is change management What is smoke Testing what is sanity testing A application is given to you but the requirements and functionalities are missing what will you do to start the testing which testing documents will be received by the client

1004


How we test the bulk of contents in web page using manual testing? Is any open source tool available for that ? Thanks in advance..

785


qtp9.2 and qtp10.0 difference

2366