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 |
What is the difference between Msgbox Statement and MsgboxQ function?
what is the difference between procedures,attributes and functions?
Dim X,Y as Integer Here what is the datatype of X and Y ?
Explain about control properties?
What is the max size of textbox?
wat is excel
What is the use of Imagelist Controls ?
What is the default property of data control?
What do you mean by Databound Controls Explain?
How would you create Visual basic Document file?
what are Instancing for classes provided by ActiveX component like prive, publicnotcreatable,SingleUse, GlobalSinleUse,MultiUse.
___ Property is to compress a image in image control.
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)