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 are all the netwoking tools, hardware tools and software tools required for testing a web-based n client server applicatopn?

0 Answers  


Explain the differences between White-box, Gray-box, and Black-box testing.

6 Answers  


What is Internalisation testing?

3 Answers   Keane India Ltd,


what is project testing & product testing, and what is the differene ? plz explan with example

1 Answers  


if u login sucessusfully in page and reach the 2nd mailing page where u find u are getting only few mails not all then wat would u say test is pass or fail

4 Answers   Sapient,


Hi Friends Please let me know that how to test font size and font type of any website content when the right button is disable and we can not copy and paste it in msword.

1 Answers  


What is the main difference between SDLC & V-MODEL. In the interview,wht exact difference,i should tell for an interveiwer

6 Answers   Accenture, kenexa, TCS,


explain the ISO standard ( more explanation about the ISO

0 Answers   ACIL, EDS,


Who assign Bug Id & Bug Version Id?

4 Answers  


Hi I am searching job please send some details abuot ERP project and real time test plan,traceability report,test case if any relate to erp project Please help me out to get a job in testing.my email address is chiku_69@yahoo.in Thank u

0 Answers  


Example For Load And Stress Testing.

2 Answers   Infoedge,


1) I have 5000 test cases within 3 working days u have to finish? How you will handle it. 2) Difference between Relase-1 and Relase-2

1 Answers   Target,


Categories