What is pivot table and how to create a pivot table
Answers were Sorted based on User's Feedback
Answer / 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 |
How many system controls are available ?
What is the use of parameters collection?
How can I access a record by record number?
Explain about form creation in Visual Basic?
What is the difference between modal and modaless form in VB?
What are the different compatibility types when we create a COM component?
How to get free file location in memory?
___,_____ and ____ container objects.
What's the maximum size of a textbox?
HTML stands for What? Use of HTML ?
What is passing by reference?
In which areas the Error occurs?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)