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 |
Types of LockEdits in RDO.
What is the different between Microsoft ODBC Driver and Oracle OBDC Driver?
What are 3 main differences between flexgrid control and dbgrid control?
What is the use of Hyperlink control for DHTML applications?
Is it possible to Access BackEnd procedures? Explain.
How can you filter out specific type of file using file system controls?
Is there any Edit method in ADO Data Access method?
Is it possible to Access BackEnd procedures?
What are the objects in ADODB?
What are different types of locks in ADODB?
what is the Difference between Dynaset and Snapshot?
What is pivot table and how to create a pivot table
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)