SQL_By_Chance (1/9/2012)
Hi,I wanted to know if we can select percent of records for each group?
something like :-
SELECT TOP 30 PERCENT *
FROM LOCATION_TABLE
GROUP BY STATE
ORDER BY CITYNAME
As you have only grouped by cityname so You can't use all column names in select list. replace * by column name which you are using in group by clause
SELECT TOP 30 PERCENT CITYNAME
FROM LOCATION_TABLE
GROUP BY STATE
ORDER BY CITYNAME