var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Distinct count?
Is it possible to use the DISTINCT keyword with the Count() function? So for example if we have a query
Then can I find out how many records this query returned? I know that I can do
SELECT DISTINCT Table1.Field1 FROM Table1 WHERE Table1.Field2 = 0;
but this would distinguish between duplicate Field1, which the first query wouldn't.
SELECT Count(*) FROM Table1 WHERE Table1.Field2 = 0;
take your SELECT DISTINCT query and save it as a saved query
then query the saved query like this --
select count(*) from savedquery
thank you , george, but as that page you linked to says, it's a "barbarous misspelling"
however, when i use it, it is ~not~ because of my reluctance to believe that OI can represent the sound "wah"
i have a different reason
Oh no you cannot leave me hanging like that!
Originally Posted by r937
I always assumed nothing more (or indeed less) than comedic value.
ur codings are working excelent.
oh yes i can ;o)
Originally Posted by georgev