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 measure group, measure? : sql server analysis services, ssas
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Where are sql server user names and passwords stored in sql server?
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
Define Foreign Key?
3 Answers ADP, College School Exams Tests,
List out the differences between the clustered index and non-clustered index in sql server?
Explain what are the authentication modes in sql server?
How to list all dsn entries on your local machine using odbc_data_source()?
What are the basic features of a trigger in ms sql server?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
How do I find the sql server version?
How to test odbc dsn connection settings?
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)