FUDforum - خوراک RDF
http://fudforum.org/forum/index.php
sql how to have the total rows number in this case nawfer
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=182512&th=123134#msg_182512
$query="SELECT *
FROM table1
ORDER BY
(CASE WHEN column2 = 100 THEN 1 ELSE 0 END + CASE WHEN column3='Y' THEN
2 ELSE 0 END) ASC, column1 ASC, column2 ASC;
how to have
a) the numeration for every row;
b) the total number of all the rows
c) the total number of column2 = 100 rows
d) the total number of column3='Y' rows ?]]>nawfer2013-08-09T14:12:41-00:00