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.
- 2 Answers
- 6339 Views
- JPMorgan Chase, Zenith, I also Faced
- E-Mail Answers
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
value momentum
Explain severity with example and expalin each example?
How do you know the code has met specifications?
through which phases a software ttester need to pass like as a junnior test engineer,team lead,project lead,etc.? which is the final stage of your promotion and how will u achieve?
what is scrum how with ex?
a newly launched web site is hosted on web server.It is expected that 100 people visit the website every hour and browse 30 pages spending a total 15 minutes. what is the maximum hits/sec that the web server should support this load?justify your answer. need urgently. by rimesh
how can we give (ASSIGN) bug privitorirs and seviroty to the bug explain with exanple
Want to learn Manual Testing in just two days? Students around Thanjavur, Trichy, Mayavaram and Kumbakonam Mail to manualtestingtraning@gmail.com. Entire Manual Testing Concept. Any doubt regarding IT Job please mail above ID
When did u complete testing ? Which scenrio should not be in automation testing ? why ?
Give me an example of something you tried at work but did not work out so you had to go at things another way.
from where do u collect test data if u miss some data what will happen
What will be your approach if a particular script in Load Test fails?
WHAT IS OBJECT REPOSITORY? AND IT TYPES? HOW MANY TYPES OF ACTIONS ARE THERE IN QTP? CAN WE ADD NEW OBJECTS AND PROPERTIES INTO SHARED OBJECT REPOSITORY?
Hi Dear this urgent for me i have need of ROLTA India Ltd Mumbai Paper pattern for Testing Person , PLease Help me , if any body have any idea about it
What are all the scenario for 1.google analytics 2.api 3.paypal
