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

In a table only one column how to update rows

Answer Posted / geetha

create a table with one column
select sno,rowid from test_table;
then use the rowid to update the col..
update test_table set sno = value where rowid =' '

Is This Answer Correct ?    10 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is raw datatype in sql?

1104


Is like operator in sql case sensitive?

1077


What is cascade in sql?

1016


What is sql partition?

1163


How do you modify a table in sql?

1163


what is not null constraint? : Sql dba

1077


How many functions are there in sql?

1094


What are tables and fields in the database?

1188


What is the difference between row level and statement level trigger?

1071


how to get a list of columns in an existing table? : Sql dba

1008


how to use regular expression in pattern match conditions? : Sql dba

1087


Can we update views in sql?

986


Is truncate ddl or dml?

1038


Which is better varchar or nvarchar?

1050


How does a covering index work?

1008