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

Hello testers I am an Bsc Hotel mgmt Degree holders but now am doin my software testin programme, side by MCA Master degree an have 6 months exp i testing in company.. i want to change my CV according IT based. so can anyone help me with sendin any sample CV of urs.. do me this favour it wil be very helpful for me prepare CV for interviews....

1695


What is the big deal about ‘requirements’?

742


functional testing and usability testing test cases for transfer funds...

1268


What r the domain for pharma, interview if they ask about phrma application, what need to tell, is there anybody have screens or any information please tell me and if have URL let me know please.

3930


What is the procedure of manual testing?

646






What is the test harness?

679


What is verification in software testing?

685


What is the difference between a defect and a failure?

662


what is mean by impact analysis ,how we used to select regression TC using this?

1606


could u pls anyone tel me .."which is the best instute that provides eficient practical knowledge and also real-time oriented knowldge to do a project in manual and automation testing..in hyd" pls send me to dis mail-id if u find any..? sinducute17@gmail.com

1663


What is software review?

812


how to write defects in excel sheets when defects occured

1532


Does an increase in testing always improve the project?

1354


what are the status have in QC(Test Management Tool). and how you report?

1463


hi... guys can any one pls help me out.... I m civil engg graduate i want to come into s/w field... i have decided to do manual testing course. i know its not sufficient.. which r the other coures shall i do with this.. suggest me good atomation tool and SAP courses... thanks in advance.. i wil be thankfull to u all

1713