More Funny SELECTs

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

richardd Hall of Fame Points: 3965 More actions · Answer 1

I assume the misleading column names were a deliberate attempt to distract from the problem? 🙂

("OrdersIn2000" for the orders in 2011 excluding 1st Jan, etc.)

Steve Jones - SSC Editor SSC Guru Points: 736297 More actions · Answer 2

SSC Guru

Points: 736297

December 4, 2024 at 6:28 pm

No just typos. A happy accident.

John Esraelo-498130 SSCertifiable Points: 5916 More actions · Answer 3

I could be wrong, nevertheless, I think I have seen it work in PL/SQL.

But definitely won't work in MSSQL

Cheers,
John Esraelo