what is the output of this query
selet * from employee where 1=2
Answers were Sorted based on User's Feedback
Answer / asha
I Agree with Satya K
If the Table contanins the columns as
EMPLOYEE table
EmpNo Ename Salary
101 Hello 1000
102 hi 2000
103 dear 3000
When you execute the above query it gives only the
structure of the table...with the blank rows
Ans : EmpNO Ename Salary
is displayed
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / jana
here only the structure of the table is available and what
ever the data is there in the table is not copied into the
other table.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / qaprofessional
This query would copy the structure, when the query is like
select into abc from xyz where 1=2 would result in the
structure of xyz getting copied to abc.
This query would return no values
Is This Answer Correct ? | 0 Yes | 0 No |
hai poonam i am rajendra
if you execute query like
selet * from employee where 1=2
here the where condition is meaningless
but you have selected all columns of data from table
it just displays all column names of table without data.
Not only where 1=2 for nay meaningless condition.
if you have still any doubt plz mail me i can send you
answers.
ok byeeeee
Rajendra Prasad Reddy
Mobile:+91-9885162742
Hyderabad.
Is This Answer Correct ? | 0 Yes | 2 No |
can any one please give bug reporting format of bugzilla ?
is it possible web application make it as executable file
what is tracebility matrix?
3 Answers InteQ Software, Syntel, Trix,
Hi Friends i have created a Community for Software Testers in Orkut with name Bug's Join in the community. you can post any type of questions related to sofware Testing in that community. Join in Bug's -- Vinodh Anandhan - vinodhanandhan@gmail.com
What is the configuration tool is using in your organization.
what we have to read to gain knowledge in banking and financial domain(software testing) for 4+ experience
For Editing functionality: If there are 10 fields on survey form.User can edit anything from theese 10 fields. User can edit only first field or he can edit 3 fields at a time or can edit all 10 fields at a time or can edit 1 field of one survey form, 2nd field of 2nd survey form, 3rd field of 3rd survey form etc. upto 10th fields or nothing will edit & close the form . My question is --> I have to write test cases for above all scenarios? Let me know it's urgent.
Guys, can any one of u give the realtime example for Black Box Testing
In Testing 10 cases you found 20 bugs then how will you know which bug is for which test case?
What is your favourite Bug?
Hi!! Could anyone tell me the risks that usually appear while testing web application [let say - eCommerce] Thanks!
what are the status have in QC(Test Management Tool). and how you report?