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

i heard that mainframe testing is diff from other environments & has lot of keyboard input????pl clarify my doubt & let me know in what way its diff??

1618


Can you explain function points?

677


what is functional testing terminologies

1906


can any one send sample test cases for database testing by taking an example? also leave emailid please. thanks (very urgent)

2649


Difference between adhoc testing and error guessing?

696






How do you go about testing a project?

1423


How can software qa processes be implemented without stifling productivity?

705


What is difference between Bug resolution meeting & Bug Review Committee? Who are participants?

2393


WHAT IS PROTOCAL TESTING..EXPLAIN? L2, L3 PROTOCALS TESTING MEANS WHAT?EXPLAIN BRIEFLY

6283


can any body tell me what is the process of between after getting a documents and testcase writing.

1508


Write the test cases for godaddy home page

1227


how to write defects in excel sheets when defects occured

1528


what are the risk factors in the project? what is the base for testplan and entry criteria ,exit criteria for test plan?

1937


How is ‘build’ different from ‘release’?

633


What is the term ‘quality’ mean when testing?

763