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 is pivot table and how to create a pivot table

Answer Posted / prasanna s chitale

HI, GUYS

PIVOT TABLE IS ADVANCE FEATURE BY SQL ANSI WITH TRANSFORM
STATEMENT. THIS REPRESENTING THE DATA IN CONSOLIDATE WAY.
FOR EXAMPLE IF WE WANT THE PRODUCT V/S MONTHLY SALE ANALYSIS
THEN IT IS POSSIBLE WITH PIVOT TABLE.

MONTH APRIL-07 MAY-07 JUN-07
PRODUCT
MARUTI-800 700 800 550
MARUTI ZEN 100 120 90

ETC

THIS IS TYPICAL PIVOT TABLE

Is This Answer Correct ?    8 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I speed up my VB database application?

1842


____ property of menu cannot be set at run time.

1727


How to find the current record position in data control?

1968


How much gain in performance will I get if I write my number crunching routines in C instead of Visual Basic?

1381


What is constructors and distructors.

2300


____ is the difference between Listindex and Tab index.

1928


How do I prevent multiple instances of my program?

1434


What is the use of Tabledef?

2030


What is file in vb?

885


What do you know about chaining views.

1059


Is there a way to break long lines in VB code?

1383


How can you Implement windows functionality in VB?

2111


What is a thread pool and how are the threads within a thread pool managed?

2032


What is Parser Bug?

2331


What are forms in visual basic?

1047