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 |
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is user-defined inline table-valued function?
What is ms sql server reporting services?
what is Equity join?
What are different types of raid configurations? : SQL Server Architecture
Do you know what are the properties of the relational tables?
Difference Between varchar and nvarchar datatype?
What is the default order of an order by clause?
What is a Trace frag?Where can we use this?
Does partitioning improve performance sql server?
What are the OS services that the SQL Server installation adds?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.