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 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

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1099


Introduction of rollup clause using sum and group by clause?

960


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8152


What is a trigger? Why we need it?

992


What are four major operators that can be used to combine conditions on a where clause?

1040


What stored by the master? : sql server database administration

1104


How to write character string constants or literals in ms sql server?

1015


Explain full-text indexing?

974


What is the concept of optimization?

1053


What is failover clustering overview?

1083


what are user defined datatypes and when you should go for them? : Sql server database administration

1017


How to create a local temporary stored procedure?

998


What are built in functions?

999


What is use of except clause? How does it differ from not in clause?

1018


Is it possible in sql table to have more than one foreign key?

1028