Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What does the slash mean in an SQL query?

Tags:

sql

mysql

What does the slash character mean in this query? This is being used with a MySql database.

SELECT Channel, COUNT(Channel) AS Total, COUNT(Channel) / (SELECT COUNT(*) FROM UserClicks WHERE (Date > '2009-12-1' AND Date < '2010-1-1') AND RoleType='member' ) AS Percent FROM UserClicks WHERE (Date > '2009-12-1' AND Date < '2010-1-1') AND RoleType='member' GROUP BY Channel ORDER BY Total DESC

Update: sorry, stupid question! =P

like image 574
Andrew Avatar asked Nov 22 '25 04:11

Andrew


1 Answers

It's a division sign. It's dividing two numbers.

like image 74
Langdon Avatar answered Nov 24 '25 00:11

Langdon



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!