charts limiting results

This topic is locked

charts limiting results	10/19/2007 6:49:27 PM
PHPRunner General questions
R roadyx author Im sure its my syntax but can i get help in limiting my chart data? select `username` , count(username) as CTotal From `customer_logs` group by username order by 2 desc LIMIT 20 <- where does this go? I tried it all over the place


R	roadyx author 10/20/2007
	Let me rephrase, my chart results are in the hundreds and I want to limit the output to TOP 20. Thanks please. Im sure its my syntax but can i get help in limiting my chart data? select `username` , count(username) as CTotal From `customer_logs` group by username order by 2 desc LIMIT 20 <- where does this go? I tried it all over the place