Oracle select * from table_name where rownum<=100; SQL server selec

Write SQL query to see first 100 recorders from table?

Question Posted / ammu

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

Please Help Members By Posting Answers For Below Questions

Which criteria should take in account while doing CMS testing of any project?

1812

How can I done a Web Testing? Which steps are include in it?

2090

which sanity testing is performed?

1724

i have source and target having same data structure 500 fields and one lacks records. how to validate data. write 5 scenarios.

5748

What is unit level testing?

1155

What is the purpose of test strategy?

1232

If there is non reproducible bug which developer is not ready to agree, how you will convince him.

9215

functional testing and usability testing test cases for transfer funds...

1832

I studied MBA, I want learn any softwarecourse, which course is better hadoop or testing tools(manual+selenium?)

1735

What is defect validity ratio?

7438

What knowledge I must have as a 3 yrs. manual tester??

2144

what is the main field of bugzilla which we fill to report bug to any developers???give some brief description??

2147

give me a example of writing a test case,take any good example which i can understand easily.

2263

what is scrum how with ex?

2171

what are questions asked in TCS for database tester (sqlserver)?ay idea

2988