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 |
when testing will starts in a project?
7.Do you have working knowledge on any international quality systems?If yes name then?
I have 3 years of experience as a software manual tester. What can i study further for a career growth. Please advice if there is anything apart from automation testing
Explain Bug Tracker
IF ASCII_CODE_OF_ENTERED_CHAR is less than 44 THEN reject it ELSE IF ASCII_CODE_OF_ENTERED_CHAR is greater than 56 THEN reject it ELSE it's a digit, so accept it Which one of the following sets of ASCII codes do you use to test the sample code above WITHOUT redundant coverage?
0 Answers CA, Dish Network, Wipro,
What is system testing? What is defect leakage? What is penetration testing? What is regression testing?
in web application , what are the common "browser compatabality issues " that you have across.?
tell me about V-Model
Give me an example of something you tried at work but did not work out so you had to go at things another way.
What is Exit Criteria and what should be covered in it?
2 Answers Power Designs, Zensar,
What is Testing in Abnormal environment? a)Stress Testing b)Beta Testing c)Performance Testing d)Security Testing
In front end if you enter one record it will be inserted in to 20 tables in back end.so How you are going to test in Manually whether data is going properly in to concern data tables or not? Is there any better solution to do that instead of opening the table and checking individually?