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 known issues?
3 Answers Mantra Media, Yardi,
What do u mean by Functional Testers and Performance Testers? Need the Answer Immediately. Thank u
What is QA Life Cycle?Can anyone describe it?
what is meant by Priority nad severity?
What is the difference between latent and masked defects?
How to write a test case for Email and web address
3 Answers PAS Technologies, TNQ, TNQ Books and Journals,
explain test life cycle
On which basis u'll prepare the test cases.
tell me about low severity & low priority bug?
4) Adhoc Testing is performed with A)A formal test plan but with out a formal testcase cool.gifA formal test case but without a test plan C) Both A and B D) None of the options
What is Bomb Testing?
difference betn adhoc testing and error guessing?