What is pivot table and how to create a pivot table
- 2 Answers
- 9765 Views
- I also Faced
- E-Mail Answers
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
How would you attach pictures in column headers of List View Control?
To.set the command button for ESC ___ Property has to be changed.
What is ODBC Direct and Microsoft Jet Database Engine ?
Explain about arrays?
DHTML Is used for what?
How do you change the system menu (on the Control-Menu Box)?
With in the form we want to check all the text box control are typed or not? How?
Difference between Linked Object and Embedded Object?
What is ado data control in vb6 0?
___,__,___ are the type of combo box?
How would you activate animation control?
How many ways you can access file using VB?
How many objects resides in ADO ?
What is the use of Hyperlink control for DHTML applications?
Is a foo VBX/DLL available as shareware/freeware?
