Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

online demo for bug tracker tool(let me know the website)

2147


is it not possible to automate full project??what r the parts in project that cant be automated(tht has to be done manually)?

2457


What is the difference between manual testing and automation testing?

1288


Hi ALl, Can you please list out Q & A for Test Lead,which Interviewer may ask in interview for Test Lead position

1978


can any one send sample test cases for database testing by taking an example? also leave emailid please. thanks (very urgent)

3180


What are the types of maintenance?

1162


Test approach to windows update?

2331


When we are recording in WinRunner and interact with the AUT, what does WinRunner do?

2028


How does compatibility testing differ while testing in Internet explorer and testing in Firefox?

3310


I have 2 yrs 10 months experience in manual testing. there is a gap of 3 yrs in between. just 3 months before i rejoined the same company. I am looking for new & better job.What I have to enhance my career to up level, should I have to do Automation course or any other. Guide me properly.

1885


why QA team is necessary for an organization?

3088


What makes a good software qa engineer?

1162


What is a critical bug?

1101


What is build interval period?

2367


diff b/w desktop based testing & web application testing

2065