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 use of partition by in sql server?
What do you mean by 'normalization'?
0 Answers Ernst Young, Thomson Reuters,
List the ways in which dynamic sql can be executed?
What are the steps you will take to improve performance of a poor performing query?
What are the different type of replication in sql server?
Can two different columns be merged into single column? Show practically?
If we shrink the Databse and Files, how much size is decreased?
What is trigger ?
How to resolve the orphan use problem? : sql server security
What is full outer join in sql server joins?
What is constraints and its types?
What is the difference between DTS and SSIS?