ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  Visual Basic
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
What is pivot table and how to create a pivot table
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is pivot table and how to create a pivot table
Answer
# 1
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 ?    4 Yes 0 No
Prasanna S Chitale
 

 
 
 
Other Visual Basic Interview Questions
 
  Question Asked @ Answers
 
What is the purpose of the DoEvents command?  2
What is DAO?  1
what is visual basic  8
What is the diff between the Create Object and Get object?  1
What are the different types of Dialog Box? Apollo1
Types of Modal windows in VB.  1
Which controls can not be placed in MDI?  1
What do you mean by ADO? TCS3
What are the different compatibility types when we create a COM component?  1
Does VB Supports OOPS Concepts? Explain..  1
What type of multi-threading does VB6 implement?  2
What kind of components can you use as DCOM servers? Hudson1
what is the diff between inprocess and out of process ?  1
what are the differences between image and picture controls?  3
Which controls have refresh method?  1
Can Redim be used to declare a new array ? Infosys8
What are different types of cursors in ADODB?  3
what are Instancing for classes provided by ActiveX component like prive, publicnotcreatable,SingleUse, GlobalSinleUse,MultiUse. HCL1
What is difference between datagrid and flexgrid? InfoWorld1
What is the difference between Single and Double in VB?  1
 
For more Visual Basic Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com