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
why QA team is necessary for an organization?
Difference between smoke and sanity testing
1. what is a date guidelines ?
tell wat u did in ur banking project?
Which criteria should take in account while doing CMS testing of any project?
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
What is configuration management in software testing ?
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...
What is smoke testing and what is sanity?
is it possible web application make it as executable file
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)
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)
What is test management?
What are different types of verifications?
What is a top-down and bottom-up approach in testing?