What are the four main query statements?
Answers were Sorted based on User's Feedback
Answer / mohan kuamr
# 3
The main four query statements are:-
1.) select
ex:select * from table_name
2.) insert
ex:insert into table_name(c1,c2,c3...) values(v1,v2,v3..)
3.) delete
ex: delete * from table_name
4.) update
ex:update table_name
set col_name='value'
where col_name='something'
note:examples are based on ms sql server database.k
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / mohan kumar.a
The main four query statements are:-
1.) select
ex:select * from table_name
2.) insert
ex:insert into table_name(c1,c2,c3...) values(v1,v2,v3..)
3.) delete
ex: delete * from table_name
4.) update
ex:update table_name
set col_name='value'
where col_name='something'
note:examples are based on ms sql server database.k
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / chandra kumar
All congraces members are currupt,mostly of them are choor
baymaan and bhrast.
| Is This Answer Correct ? | 1 Yes | 6 No |
How do I view a trc file?
What are secondary xml indexes?
Define full outer join in sql server joins?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What are sql dirty pages?
when you create a database how is it stored? : Sql server database administration
What are the 10 characteristics of data quality?
What is policy based management (pbm)? : sql server database administration
Explain acid?
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)