Interested to Buy Any Domain ? << Click Here >> for more details...
What is pivot table and how to create a pivot table
- 2 Answers
- 10464 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
Difference between DDE and OLE.
Types of ActiveX Components in VB?
Which type of object requires this object?
Draw Sequence Modal of DAO and Explain?
What is ActiveX Document?
How do I make my applications screen-resolution independent?
Which type of object requires this object?
What is the default model of the form?
what is the Difference between Recordset and Querydef?
Is it possible to Access BackEnd procedures? Explain.
what are the Types of Resultsets?
What is ado in vb.net?
How to use advanced data-bound controls.
Difference between ActiveX Control and Standard Control.
What is Internet Explorer and its uses?
