General Questions
- Behavioral Questions
- Illegal Interview Questions
Technical Questions
Project Management Questions
Interview Puzzles
Interview Advice

Explain difference between Pivot and Crosstab Query

Posted by _samal

Recent question for DBA position in NYC. My answer about Pivot tables in Excell didn't work very well. Interviewer was keep asking about what is crosstab query and how would I use it.

1 Answer

Programming Interview Questions | sql pivot query crosstab all All

Answers and Comments

Written by CMaster

There is no difference. Basically you use pivot(or crosstab) queries then you are trying to create result set then row become columns or columns become rows. You can use PIVOT SQL statement to achieve it.

Here is the info on Oracle blog:
http://thinkoracle.blogspot.com/2005/09/pivot-and-crosstab-queries.html

More info on crosstab queries
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=25

Saved Stories

Tell us about the last time you lost your temper? Did you take personal accountability for this situation?
Disk spinning puzzle
What is GAAP? Name at least three of the principles
Can a Silverlight application create or change Office Documents via Open XML?
How would you sort a linked list?

Explain difference between Pivot and Crosstab Query

Associated Questions

Answers and Comments