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

What is a Show Stopper?

14 Answers   HCL,


6. What do you dislike about each of the Web sites?

0 Answers  


What is the significance of version control in software testing

1 Answers   IBM,


how many phases in SDLC

10 Answers  


Do you think tools are required for managing change. Explain and please list some tools/practices which can help you managing change.

0 Answers   Ordain Solutions,


How many Test Cases can u write for the Login Page Scenario?

8 Answers   Accenture,


how to write integrated test case for an ATM?

4 Answers   IndiumSoft,


What r the input documents to the design test cases?

7 Answers   Covansys,


Define brain stromming and cause effect graphing?

0 Answers  


What is the difference between Use case and Test Scenario? Explain the Architecture of u r project?

1 Answers   CSS,


i'm 2007 passed out.I'm very much interested in testing.i tried very hard to get a job.wat to do if i don't get a job in small company also?

5 Answers  


diffrence between application testing and product testing?

9 Answers   Satyam,


Categories