How to update existing rows in a table?
Answer / priyanka rani
By using Update statement. For example Update table_name set column_name='value' where column_name='your condition'
if required use where condition
| Is This Answer Correct ? | 0 Yes | 0 No |
How to divide query output into multiple groups with the group by clause in ms sql server?
What are the differences between substr and charindex in sql server.
How to list all tables having unique constraints in any of the columns in a database.
How to run queries with sql server management studio express?
What is optimistic concurrency?
What is a mixed extent?
Is mysql the same as sql server?
What is a natural primary key?
What are the different types of backups that exist?
9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18
Do you know what is sql injection?
What are the disadvantages of using the stored procedures?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)