Write SQL query to see first 100 recorders from table?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

why QA team is necessary for an organization?

2583


Difference between smoke and sanity testing

1268


1. what is a date guidelines ?

1623


tell wat u did in ur banking project?

1821


Which criteria should take in account while doing CMS testing of any project?

1277






hai friends, I need clarifications for some doubts in testing terminology. 1.What is thread testing. 2.What is bucket testing and which automated tool is used to do this test. 3. ERP testin automation testing. 4.What is Data Warehousing testing? 5.What is Implementation testing? 6.What is Shake out testing? please let me have the clarifications in detail

1519


What is configuration management in software testing ?

4202


What will be the testcase for a uniquely generated number in the application?? i mean to say is, how will i conform the application is generating a unique value.... please do answer...

1708


What is smoke testing and what is sanity?

625


is it possible web application make it as executable file

1864


we are about to implement a Test tool to test the performance of website, so what script does a tester should know (friends plz help me)

1488


What are the possible test scenarios around AVS check of any credit card? (Testing through payment gateway online) (What are the fields we should check while checking AVS and CVV)

1082


What is test management?

1410


What are different types of verifications?

676


What is a top-down and bottom-up approach in testing?

673