Can any one give answer for this question. Suppose im having
employee table with fields, eno, ename, dept, address1,
address2, address3. In address field employee can fill only
address1 or address2 or address3... at a time he can fill
three address fields. now i want all employee names who
filled only one address field.. Plz its urjent can any one
give querry.. Thanks in advance.
Answer Posted / nitin sharma
select ename from employee where adress2 and adress3 is NULL;
| Is This Answer Correct ? | 5 Yes | 13 No |
Post New Answer View All Answers
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?
Is there any procedure of web-site development in manual testing. If yes what are factors we should test?
On what basis you are fixing up the time for project completion?
Can any one please tell me which is the best institute in Bangalore to learn QA (crash course)? Thanks
What are the basic forms of variations?
Should testing be done only after the build and execution phases are complete?
How to write testcases for unread/read mails for gamil inbox? and what are the types of testing you do on them?
What is an end-to-end testing?
what is the difference between website and web based application ?
how to write the test cases for mark as read/unread mails for gmail inbox?and what are the testings we will do?
What is change request, how you use it?
when do you escalte issue to your manager?
What is verification in software testing?
When the GUI Testing will be held on the V model ?
what is test case management?explain in brief.