SELECT 1 AS Deptnumber , Dept FROM tbl_students WHERE Dept IN ('A', 'B', 'C') UNION SELECT 2 AS DeptNumber , Dept FROM tbl_students WHERE Dept IN ('D', 'E') UNION SELECT 3 AS Deptnumber , Dept FROM tbl_students WHERE Dept IN ('F') Reference : https://stackoverflow.com/questions/1775168/multiple-select-statements-in-single-query https://kb.objectrocket.com/postgresql/postgres-loop-types-1027
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter