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 |
What group of teams can do software testing?
how to test the case with 5 combination and inputs
what is the difference b/w Priorty and severity in Bug Report
22 The main focus of acceptance testing is: a) finding faults in the system b) ensuring that the system is acceptable to all users c) testing the system with other systems d) testing for a business perspective e) testing by an independent test team
what is difference between metric and report ?
What is diff between Defect density metrics and Defect Variance metrics ?
how many phases in SDLC
Provide an Example with ‘High severity and low priority’ and ‘Low severity and High priority’.
Gv example of a defect with high priority and low severity? Gv example of a defect with high severity and low priority?
Difference between Quality Assurance and Quality control? What does the QA ppl do?
What is Tracebility Matrix ? What is there in that and what will u do with that ?
how many members are involved in test plan? and tell me names?