What is pivot table and how to create a pivot table
- 2 Answers
- 9963 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
What is the use of Active Control Property?
How do you make a TEXTBOX read only? Or, how do I prevent the user from changing the text in a TEXTBOX?
How do I remove/change the picture property of a control at design time?
What is ado data control in vb?
With in the form we want to check all the text box control are typed or not? How?
How can I change the printer Windows uses in code without using the print common dialog? How can I change orientation?
Write the Steps in Creating an ActiveX Control?
What is meant by Establish Connection in RDO? 74.1s it possible to Access BackEnd procedures? Explain.
What is the use of command Object?What are the various types of variables?
How would you find out the value property in Slider Bar Control?
How do I create a window with a small title bar as in a floating toolbar?
How do I force a file dialogue box to reread the currect disk?
Give brief description about class?
What is the difference between change event in normal combobox and dbcombobox?
what are the Default cursor Type and LockEdit type in DAO?
