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
can we do database testing in manual testing? then how we write the test case?
What are the different test techniques used in functional testing?
What is the quality process is following in your organization.
what is meant by application server and its functions?
Can you please explain about the erp project
What was a problem you had in your previous assignment (testing if possible)? How did you resolve it?
Does anyone have any good examples of some acceptance criteria for non-functional requirements?
What is localization testing (l10n testing)?
Hello again!! wanted to ask you HOW EXACTLY create stubs and driver in integration testing? 2.whats the difference between integration testing and system integration testing? Thanks!!
You may undergone many projects. Do all the projects match up with customer’s expectations?
I have an UI issue "please fill out this field" pop up in firefox browser keeps scrolling with the page is it valid???
What are testing techniques? What is difference between general and specific?
can u merge 10GUI map files into a single GUI map file in winrunner?
what kind of testing have u done?
What is ofx testing?