Write SQL query to see first 100 recorders from table?
- 9 Answers
- 8909 Views
- I also Faced
- E-Mail Answers
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
Hello. I am not here to answer your question. I jus found a job as software QA engr. And i am totally new to software testing. So can someone pls help me in the following scenario? there is this registration screen, and it contain: One textbox called Nickname which only accept alphanumerical One textbox called Contact which only accept numerical, One textbox called Email which can be filled with alphanumerical and symbol and One button called Register now becos there is so many textboxes, where i can filled with alphabet, number, symbol, "just space", leading zeros, leading space. there will be lots of combination. can someone pls help.. i will be appreciated if u can post the test case of the scenario i mentioned. Lots of Thanks
What is rapid application development model (rad)?
What is Dynamic Binding and Dynamic Loss?
Are there more defects in the design phase or in the coding phase?
how will we change the server system time?
after completeing testing ,what would u deliver to the client?
Hi friends Does anyone have screen shot of POWERMHS and please can anyone post anything which will be helpful to understand POWERMHS. thanks.
What is defect validity ratio?
What is Batch testing? Facets Benefit Configuration
Describe Testing Decomposition?
You must test a trouble report where the problem cannot be reproduced. You tried using various test data files and mutations from the data files the customer sent along with the trouble report. The software does not fail the way it did at the customer's site.
Explain the procedure for manual testing.
Why performance testing is performed? What are tools of performance testing?
When new application ready to test than whats your testing strategies?
Hello, I want to know how to write a regression test plan? Can someone please send me the format/template? Thanks in advance
