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

Define brain stromming and cause effect graphing?

86


why use caffine for HPLC calibration ?

1033


Can you explain the various elements of function points ftr, ilf, eif, ei, eo, eq, and gsc?

79


what is the function generator?

1076


What r the documents required for performance testing

1259






Define what is a critical bug.

68


define Testing of Procedure, Triggers and Functions in data base testing ?

2459


How to test the Online Games?? Suggest tricks. I have experience in server-client application testing.

841


consider therez 1 land and it has mango trees in it, what are the tets cases or how will we count no of mangoes on all trees

1001


what is mean by impact analysis ,how we used to select regression TC using this?

1018


Changes and enhancements to system?

994


What is unit level testing?

84


how to test a web application manually?can u explain indetail?

1014


If asked to create a Configuration Design Pattern, where would you start?

685


What is Registry?

1068