FUDforum: comp.lang.php » sql how to have the total rows number in this case

Home » Imported messages » comp.lang.php » sql how to have the total rows number in this case

Show: Today's Messages :: Polls :: Message Navigator

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:

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

Report message to a moderator

[Message index]

sql how to have the total rows number in this case

By: nawfer on Fri, 09 August 2013 14:07

Previous Topic:	Dictionary Words
Next Topic:	sql how to have the total rows number in this case nawfer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 12:14:34 GMT 2024

Total time taken to generate the page: 0.03913 seconds