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...


table X havng 3 column A,B,C....A column havng data 10 20
30.....now i wanna have 1o value in A columns all three rows

Answers were Sorted based on User's Feedback



table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / navnee

update X

set A=10

where A=20 and A=30

PLZ C0RRCT MY QUERY

Is This Answer Correct ?    10 Yes 2 No

table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / prakash

update x set a=10
where
A!=10

Is This Answer Correct ?    5 Yes 1 No

table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / ravikumar3123

update x set a=10

even this wil do..

Is This Answer Correct ?    5 Yes 2 No

table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / thilaka

SELECT * FROM X WHERE A= 10

Is This Answer Correct ?    6 Yes 4 No

table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / ramthiraviyam

UPDATE 0X SET A=10 where A!=10

Is This Answer Correct ?    0 Yes 0 No

table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / n@n!

hi Ravikumar3123,

where ever ur writting the querie is for update row in a
table.
but the row is already in the table.so,what is the
necessity of using update querie?

the question is finding the low value in the colomn 'A'
so,i think what ever the querie that am written above is
true.
plz check it out.

Is This Answer Correct ?    1 Yes 3 No

table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A co..

Answer / n@n!

select * from X where A < 10

Is This Answer Correct ?    0 Yes 10 No

Post New Answer

More Manual Testing Interview Questions

Difference between Stakeholder and Relevant Stakeholder?

0 Answers   Midas Technologies,


Can we use automation tools during static testing? If yes when and how?

3 Answers  


If we got build [say 2.0]to test, we test it & maintain the log then we got same build [say 2.0] fixing bugs in the same version 2.0 again we test it .My question is How we maintain this second log of testing same build

1 Answers  


what is the need of black box testing after completing white box tesing?

2 Answers   Cognizant,


there are many test cases in our test case repository like function,integration,system,acceptance test case so which test case should test engineer test first.? please answer me . thanks

3 Answers   century,


What do you mean by Cause Effect Graphing? in which standard its mentioned?

0 Answers   Amdocs,


Can the system testing be done at any stage?

1 Answers  


what is exemption and resumption criteria in test plan?

1 Answers  


what are the different testing methodologies and testing techniques? Am asked in interview that what is the defect age? I replied that the time gap between the defect reporting and defect resolving. then the interviewer asked me if at all the defect is not resolved then what is the defect age of that particular defect? can anybody answer this?

3 Answers  


Build with fixes has been deployed on QA environment if asked by your manager to reproduce how can you reproduce the issues? (by using the previous build) Can you access the previous build? If so ,what are the tools or how can you access?

0 Answers   Bosch,


Very Important Note for all the Testers!!! As the S/w Boom is getting considerably decreased...

13 Answers   Accenture,


How do you survive chaos?

1 Answers  


Categories