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 Query Execution Plan? How does it help optimize or tune a database driven application?
What guidelines should be followed to help minimize deadlocks?
How to use the inserted and deleted pseudo tables?
What is public role in sql server?
How do I view a stored procedure in sql server?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What stored procedure would you use to view lock information?
Explain logical operators in sql server?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
11 Answers World Tech, Yardi Software,
What is split brain scenario in DB mirroring?
Define master database?
Why people hate cursor?