get statis values sql 1

get statis values sql

SELECT 'Jan' AS Qtr1, 'Apr' AS Qtr2
UNION ALL SELECT 'Feb' AS Qtr1, 'May' AS Qtr2
UNION ALL SELECT 'Mar' AS Qtr1, 'Jun' AS Qtr2

Here is what the above code is Doing:
1. Create a table called Qtr1 with the values Jan, Feb, Mar
2. Create a table called Qtr2 with the values Apr, May, Jun
3. Create a table called Qtrs with the values Jan, Apr, Feb, May, Mar, Jun

Similar Posts