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 is Test Strategy and Test Plan..what is the Diff.between those?
What is Forward and Backward compatibility? How will you write test cases for compatibility testing?
.what are the types of recording modes in winrunner 2.what are the three modes of running a test in winrunner 3.what is synchronization point 4.what are the contents present in a test case 5.do we need testing for the project 6.what is code review and code walk through At which phase the testing starts (begin) in the project How do we test Client server applications and a Web applications what is verification and validation what is adhoc testing what is traceability matrix what is base line document what is Test Life Cycle what is regression testing and retesting what is a BUG LIFE CYCLE what is a Bug what are defects what is functionality testing and system testing. a project has to be released in one day but the testing people got that project from the developers half of the day before so what they have to do to complete the testing process. 20 what are severity level and priority levels
How to write testcases for unread/read mails for gamil inbox? and what are the types of testing you do on them?
What is the meaning of incident in testing?
what is testing management methodologies?? plz help me
self join query in sql. 15 objective questions. What is equi join and outer join
When do you escalate issues to your Manager?
What are the different types of testing u r doing in ur project
what is srs or brs file
How to prepare web applications use case document.can you send the some sample use case document for web application Project?
Give me atleast 10 cases of GOOGLE search engine?