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 |
What is the difference between a function and a stored procedure?
What is the use of tempdb? What values does it hold?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
Explain the advantages of merge replication?
What is subquery? Explain the properties of a subquery?
What is the simplest way to create a new database in ms sql server?
What are constraints?
Explain log shipping and mention its advantages.
What is the significance of master, tempdb and model databases?
How can i Relate Tables in SSIS
Do you know what is sql injection?
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?
Oracle (3253)
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)