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.
Answers were Sorted based on User's Feedback
Answer / raj
Select ename from employee
where (adress 1 is not NULL and (adress 2 and address
ISNULL)) OR (adress 2 is not NULL and (adress 1 and address
3 ISNULL)) OR (adress 3 is not NULL and (address 2 and
address 1 ISNULL))
Is This Answer Correct ? | 29 Yes | 0 No |
Answer / nitin sharma
select ename from employee where adress2 and adress3 is NULL;
Is This Answer Correct ? | 5 Yes | 13 No |
Did you ever worked with BA's?
1 Answers Standard Bank, Wells Fargo,
What is a Data Guidelines?
What does entry and exit criteria mean in a project?
how to write testcase for this particular textbox.i have textbox and it accepts only values from 1-9.how to write testcases for this using bva and ecp?need some more testcases any sites which provide testcases information? mainly for webapplication.
what is Inspection?
Hi, I want to apply jobs on manual testing with 6 months experience can any body sent a cv.
If you have executed 100 test cases ,every test case passed but apart from these testcase you found some defect for which testcase is not prepared,thwn how you can report the bug?
how do you manage the testing for enhancement projects
what is system testing? explian with scenarios..
TestCase for White Paper?
what is the difference between test plan and test strategy?
What different impact rating’s you have used in your project?