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
What is the difference between SIT AND IST?
What is frame level testing and how do we test it?
When did u complete testing ? Which scenrio should not be in automation testing ? why ?
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...
How do u go about testing of web application?
Hi Could someone please provide Siebel Testing Interview questions for 5 years exp.
what is Test management fundamental?
Changes and enhancements to system?
Can you explain the various elements of function points ftr, ilf, eif, ei, eo, eq, and gsc?
What were the major challenges u faced while testing
A form has four mandatory fields to be entered before you submit. How many numbers of test cases are required to verify this? And what are they?
what is functional testing terminologies
Can you explain the elementary process?
what does 80hz refresh rate indicates?
I know functional test cases are derived from frs and system design specs. But are test cases for performance, database, boundary, relational integrity and other types of tests other than functional tests created from frs and system design specs as well? When are these test cases created? Are they in the same test plans alongside functional test cases or is their a different test plan that includes these test cases?