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


Please Help Members By Posting Answers For Below Questions

How will you determine when to stop testing?

839


online demo for bug tracker tool(let me know the website)

1834


How we will test ubercate

1780


Hi everyone, My name is Salil Mishra. I am having 1.7 years of experience in manual testing. But as i m 2008 passout, there are limited position for me in the companies. Please help me out in getting a good job guys..I f you find something then please mail me at salilmishra29@gmail.com

1726


What is Snapshot Testing? When we need to do and who will involve in this process and also what is the output document of this testing

2663


Can you explain a pair-wise defect?

906


how to creat 2 test plan in 2 different environment exp:tour and travel

2162


What is function points??????

1775


What is a failure?

994


what is system testing? as test eng, what do u do in sys testing? who invoves in sys testing?

2069


How would you test a service oriented architecture (soa) web application?

924


Who are all involved in an inspection meeting?

860


Hi All. How can we write negative test cases for Logout Operation ? Please place the answer with a few details and if possible add some related object properties. "A tester exposes his/her ability not only by words he/she also proof it by work"

2766


I have 2 years of exp. in testing and looking for a change if any body knows, about any vacancy in testing then plz contact me on deepti_ac@yahoo.co.in

8785


Tell me the advantage and disadvantage of cookies?

1023