SQL TIPS
In subqueries, regardless of whether one row or multiple rows are returned, each of these rows contains only one column worth of data to compare to the main query level. The main query can be set up to handle multiple columns in each row returned, too.
For example
select deptno,ename,job,sal, from emp [...]
Continue reading about SQL TIPS : Writing Multiple Column Subqueries
In this tutorial we can see how to convert rows into columns using Structured Query language SQL. We cover this tutorial from the basic steps i.e creating tables and inserting values into the table so that it can be useful for basic users as well
Continue reading about SQL Tutorial : Converting Rows to Columns
