what is the output of the query select * from emp where 1=2

Answer Posted / vikas patil

It is used only for condition checking
for example select * From emp Where 1=2;
it will return 0 rows
select * From emp Where 1=1;
it will return all rows
select * From emp Where 1<2;
it will return all rows
select * From emp Where 1<=1;
it will return all rows

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

For any web application, what are the possible login features that should be tested?

826


1) how will you do validation testing in combo box ? (2)Suppose user does not want maximum length validation message, but when tester inserts data in textbox and it gets truncated, how will you resolve this issue ? (3)if a user inserts maximum number in quantity textbox in a PHP based web application then what result will show?

1580


Explain Single View Testing ?

1011


Any one send me sample question for multimedia testing with microsoft access database. I am having interview next week. Please post it or send me my personal e-mail. Thank You

1593


what is configuration management tool - send to thanu_santo@rediffmail.com. what is testing senarios

1750






How can you do the scalability testing?

710


How to validate a Testcase.and is the testing Methodology.

1852


How can a LOG for testcases be maitained which can give information about a TestCase that is it new one or has been occured in previous versions of the software.

1612


What are the bugs we cannot find in black box?

710


wat is meant by frontend and backend testing

5288


What is a failure?

812


after completeing testing ,what would u deliver to the client?

1627


1...DIFF BETWEEN QTP AND WIN RUNNER? 2... CHECKPOINTS AND EXPLAIN EACH OF THEM? 3...WHY IS STEP GENERATOR? 4... WHAT IS THE DIFF BETWEEN FUNCTIONS AND SUB ROUTINE?

1465


How to integrate Bugzilla with QTP?

2311


Different types of design diagrams that supports to write test cases ?

1893