What are the four main query statements?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain a differential backup?

751


Which is faster statement or preparedstatement?

698


What is ddl command?

697


which backup strategy you are following at ur company

1930


What is unpivot?

775






Difference between uniqe index and uniqe constraint?

716


How do I trace a query in sql server?

699


Explain transaction server auto commit?

717


What is the difference between osql and query analyzer?

714


Explain database normalization?

871


Why should you use or avoid select * statements?

733


What happens if null values are involved in bitwise operations?

792


What is code near application topology?

240


What is the main difference between ‘between’ and ‘in’ condition operators?

793


Explain sql server service broker?

701