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 explain how to elaborate on the types of system/functionality for testing Payments, Statements, & Transactions features in a bank.....like what do we test in these,in detail? It's urgent, please reply...thanks in advance.
What is security Hole ? Is this possible Some one can acess any of restricted page (like admin side)? How you test this previllaze?
Can anybody give me some tips on how to face telephonic interview and Write some expected telephonic questions as a 2+yr exp. in testing. Try to give Ques. that u already hv faced in telephone. Plz Help me out friends.
Why performance testing is performed? What are tools of performance testing?
Give the real-time example for back-to-back testing?
What is bucket testing?
Hi Friends, This is Chennamsubbaraidu.i Have 2+ Years Realtime Exp in Manual Testing.Am Looking to Shift From My Present Company.Please if u Have Any Openings in Your Company's, Please Let Me Know.Any Location Prefer.Thanks.
What is benchmark testing? hi friends... can anyone suggest the correct answer plz...
Hi, I was asked following question during a interview. Please answer it: Password field is there,we can accepts every character except underscore and semicolon. It can accept min 6 characters and maximum 12 characters. Prepare boundary value and equivalence class test cases.
What criteria would you use to select Web transactions for load testing?
What are the properties of a good requirement?
What is sanity?
What is the first test in software testing process?
Which are the standards for software test plans?
What is bug priority?