GET VALUES IN CSV FORMAT

SELECT * FROM ORDERS

GO

--TOTAL NUMBER OF ROWS IN ORDERS TABLE

SELECT COUNT(*) TOTALROWS FROM ORDERS

GO

--TOTAL COUNT OF ROWS GROUPED BY P_ID

SELECT COUNT(*)CNT,P_ID FROM ORDERS

GROUP BY P_ID

ORDER BY P_ID

GO

--EXAMPLE OF TOP 2 RECORDS

SELECT TOP 2 * FROM ORDERS

ORDER BY P_ID

GO

--EXAMPLE OF TOP 2 WITH TIES

SELECT TOP 2 WITH TIES * FROM ORDERS

ORDER BY P_ID

GO

GO

--CHECK TABLE COLUMN

SELECT LASTNAME FROM PERSONS

GO

--GET CSV VALUES

SELECT STUFF((SELECT ','+P.LASTNAME FROM PERSONS AS P

ORDER BY P.LASTNAME

FOR XML PATH('')),1,1,'')AS CSV

GO