Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are the four main query statements?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we do dml on views?

950


What is dknf in normalization form?

1047


Explain what is the difference between union and union all?

1003


What is raid and what are different types of raid levels?

1142


New concepts of sql server 2005 use in your project.

2357


How to see the event list of an existing trigger using sys.trigger_events?

1069


Explain what are partitioned views and distributed partitioned views?

939


When would you use it?

987


What is explicit mode in sql server?

1055


Explain how you can configure a running aggregate in SSRS?

163


why would you call update statistics? : Sql server database administration

1079


What is a primary key?

948


You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

310


How would we use distinct statement? What is its use?

1069


What is the maximum size per database for sql server express?

1042