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
How can I speed up my VB database application?
____ property of menu cannot be set at run time.
How to find the current record position in data control?
How much gain in performance will I get if I write my number crunching routines in C instead of Visual Basic?
What is constructors and distructors.
____ is the difference between Listindex and Tab index.
How do I prevent multiple instances of my program?
What is the use of Tabledef?
What is file in vb?
What do you know about chaining views.
Is there a way to break long lines in VB code?
How can you Implement windows functionality in VB?
What is a thread pool and how are the threads within a thread pool managed?
What is Parser Bug?
What are forms in visual basic?