What is a crosstab query?



What is a crosstab query?..

Answer / Sarvesh Khan

A Crosstab (or Pivot) query in MySQL is used to convert rows into columns and vice versa. It helps in presenting data in a tabular format where one table value is represented as multiple columns.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do I enable mysqli extension?

1 Answers  


What is deterministic in mysql?

1 Answers  


Give string types available for column?

1 Answers  


Does facebook still use mysql?

1 Answers  


Explain advantages of MyISAM over InnoDB?

1 Answers  


How to convert character strings to numeric values?

1 Answers  


How do I change directories in mysql?

1 Answers  


How do you insert a table?

1 Answers  


What is ISAM?

1 Answers  


Is there a way to see the files which are stored?

1 Answers  


what is JOIN? Give example & types of join?

14 Answers   iMedia, Millennium, RAM Software, Satyam,


What is the usage of ENUMs in MySQL?

1 Answers  


Categories