Write SQL query to see first 100 recorders from table?
Answers were Sorted based on User's Feedback
Answer / ammu
SQL server
select top 100 * from table_name;
Oracle
select * from table_name where rownum<=100;
MySQL
select * from table_name limit 100;
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ranjeet verma
select top(100)* from emp
select top 100 * from emp
Select * from emp where rownum<=100
select top 100 percent * from emp
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / shiva ch
Select TOP(100) from emp;
Displayed first 100 columns in emp table
Is This Answer Correct ? | 0 Yes | 1 No |
Diff between static and dynamic review?
hai suppose if i want to delete cookie of a particular web site.is it possible if it is possible how? pls. tell me
what the diff b/w Smoke Testing and Santy Testing?
10 Answers Cap Gemini, Financial Technologies,
1:differenciate between functional regression and gui test cases 2:for a given requirement how to write test case and prepare test data with example like for monster.com front page what testing techniques are used at what requirments see monster page 3: can we test without front end application and can we perform testing without back end application 4:all possible questions asked on bugzilla plz answer as soon
Web application is having a client and a client-server application aslo have a client. Then what is the technical difference between thease two clients? can any body expain?
In which phase the GUI Testing will be held on V model?
How to test Reports manually?
what are the type of test strategy
Explain Bug Life cycle What is integration testing and regression testing What is verification and validation How does winrunner recognizes the project which is in custom build What is expert view and tree view How does QTP identifies the project What is the difference between Winrunner and QTP What is Test Director and which version of test director your are using in your project What is a test plans what are the contents present in a test plan What is the risk of testing a project
difference between sretagic test plan & test plan?
What methodolgies you used to develop test Cases?
what is seviority and priority, and who will assign seviority and priority and High seviority and high priority , High seviority and Low priority and Low seviority and High priority and Low seviority and Low priority-- pls, if you know really give the answer,because in every interview they are asking plssssssss
8 Answers Deloitte, QuinStreet,