Home »
Imported messages »
comp.lang.php »
sql how to have the total rows number in this case
| sql how to have the total rows number in this case [message #182511] |
Fri, 09 August 2013 14:07 |
nawfer
Messages: 34
Registered: August 2011
Karma: 0
|
Member |
|
|
in this select
$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
|
|
|
|
Goto Forum:
Current Time: Wed Sep 18 13:05:55 GMT 2024
Total time taken to generate the page: 0.04161 seconds
Calendar
Search
Help
Members
Register
Login
Home
]