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

how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c

Answer Posted / hannan oca

delete from tablename; will remove all records but we can
rollback these values.

truncate tablename; will remove all records but we cannot
rollback the table values if we want that values in future.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I order columns in sql?

1012


What is pls integer?

1048


Can sql developer connect to db2?

1056


Is sql a dbms?

1017


What is blind sql injection?

1079


Can dml statements be used in pl/sql?

1081


How to convert comma separated string to array in pl/sql?

1187


How do you concatenate in sql?

1029


Is coalesce faster than isnull?

966


What is view explain with example?

935


What are different types of queries in sql?

1121


how many sql dml commands are supported by 'mysql'? : Sql dba

1125


What are predefined functions in sql?

1048


How to select random rows from a table?

1081


Differentiate between pl/sql and sql?

1153