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
Which criteria should take in account while doing CMS testing of any project?
How can I done a Web Testing? Which steps are include in it?
which sanity testing is performed?
i have source and target having same data structure 500 fields and one lacks records. how to validate data. write 5 scenarios.
What is unit level testing?
What is the purpose of test strategy?
If there is non reproducible bug which developer is not ready to agree, how you will convince him.
functional testing and usability testing test cases for transfer funds...
I studied MBA, I want learn any softwarecourse, which course is better hadoop or testing tools(manual+selenium?)
What is defect validity ratio?
What knowledge I must have as a 3 yrs. manual tester??
what is the main field of bugzilla which we fill to report bug to any developers???give some brief description??
give me a example of writing a test case,take any good example which i can understand easily.
what is scrum how with ex?
what are questions asked in TCS for database tester (sqlserver)?ay idea