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 |
How do you go about testing a project?
Hello Friends, I m working as tester in a company, i have 1.5 yrs of exp., in my company we used manual testing Technique & i wants to give The ISTQB Certified Tester-Foundation Level certificate Exam. Can any one tell me the next date of the exam.? If anyboady have questions papers OR any material then pls. frwd me on my id : preet45p@yahoo.com Thanks in advanced.
who prepares the use cases?
explain functionality testing and functional testing and give example who do thattype of testing
what is smoke testing?
Which was the most interesting bug you found.
When to do Black box testing?
Please tell me some test cases for GOOGLE.COM
Contents in Tracebility matrix?
14 Answers JVS, NIIT, TCS,
How to conduct Regression Testing Manually?
WHAT IS SECURITY TESTING.HOW TO DO SECURITY TESTING.IS THERE ANY FRAMEWORK AVAILABLE
Differentiate verification and validation?