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 / 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 |
Post New Answer View All Answers
What are the queries mostly asked in testing ? give me some examples.
hi i want manual testing interview question(3+exp)please tell me
I need your help, actually am facing lots of problem in interview am not able to answer in right way what ever questions asked about project. Could you please answer few questions? You must have seen the project I have mention as current project so please help on this, tell me how to explain project in details am prepare on HR module but don’t know how to explain it properly. If you can send me few documents like SRS, and few test case that will help me to get the clear picture, and want ask u what is tier1, tier2, and tier3 in project.
Define performance and stress testing?
What are the possible test scenarios around AVS check of any credit card? (Testing through payment gateway online) (What are the fields we should check while checking AVS and CVV)
How do you get programmers to build testability support into their code?
Which was the most interesting bug you found.
What is meant my Firewall testing? how the testing is performed on it?
Hello can anybody list out supported and unsupported browsers for Window OS,Android OS,MAC OS Ubuntu
Hi Everybody could you please send me the ISTQB Material to my mail id karthik18487@gmail.com Thanking you in advance
Hi,all i have a desktop App. which have a feature, It's a demo version if u want full version then u have to perches it. Pls give me some idea ASAP how can i break the App.
How do you know the code has met specifications?
What are the factors affecting a manual testing project and what are the ways to overcome it?
sanity testing is done during regression testing.is it true.if it is true plz explain?
Can Anbody please send me Daily Work status format in which I can save my daily work activity