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

What type of metrics would you use?

1030


Hello. I am not here to answer your question. I jus found a job as software QA engr. And i am totally new to software testing. So can someone pls help me in the following scenario? there is this registration screen, and it contain: One textbox called Nickname which only accept alphanumerical One textbox called Contact which only accept numerical, One textbox called Email which can be filled with alphanumerical and symbol and One button called Register now becos there is so many textboxes, where i can filled with alphabet, number, symbol, "just space", leading zeros, leading space. there will be lots of combination. can someone pls help.. i will be appreciated if u can post the test case of the scenario i mentioned. Lots of Thanks

915


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

3439


What are the cases why parameterization is necessary when load testing the Web server and the database server?

793


Risk Analysis a) 2 step, b)3 step, c) 4 step, d) 6 step

944






Can any one suggest how to write the bug reports effectively by optimizing what we want to describe?

807


what could be the (realtime)bugs you come across in job portal and health care projects in terms of 1. high severity n low priority 2. high severity n high priority 3. low severity n low priority 4. low severity n low priority? pls its very urgent thanks n in advance n lukin forward for reply

1020


What do you mean by Cause Effect Graphing? in which standard its mentioned?

918


what is scrum how with ex?

810


KINDLY FORWARD ME THE INTERVIEW QUESTIONS & ANSWERS FROM REAL TIME POINT OF VIEW FOR 1.5 YEARS EXPERIENCED CANDIDATE. MY EMAIL ID IS sky_bird433@yahoo.com

1577


Am putting E-commerce project in my resume can any one please tell me about E-commerce application explaination..

1731


In our project, we use Withdrawal Indent, we are confused to use heading as "Withdrawal Indent" or "Withdraw Indent". Please suggest me which one to use ASAP, Thanks in advance

841


what are the templates for daily,weekly and monthly reports? plz reply ASAP.

841


Our software designers use UML for modeling applications. Based on their use cases, we would like to plan a test strategy. Do you agree with this approach or would this mean more effort for the testers.

921


Scenario-based testing Option 1 concentrates on actor and software interaction Option 2 misses errors in specifications Option 3 misses errors in subsystem interactions Option 4 Both 1 abd 2

1870