Jeffrey Allen

Show:

What's happening?

  • Problems Converting ROW()m ROW_NUMBER() OVER to MySql

    The command line utility doesn't seem to be correctly converting ROW(), ROW_NUMBER(), and ROW_NUMBER() OVER() queries correctly. See sample below: SELECT Id, Email, EmailType, ContactPersonId, ConcurrencyId FROM( SELECT ROW_NUMBER() OVER(ORDER BY Id) AS Row, Id, Email, EmailType, ContactPersonId, ConcurrencyId FROM EmailAddress) AS EmailRows WHERE(( Row between( startRowIndex) AND...

    2009-03-10 14:02:46 UTC in T-SQL to MySQL procedure converter

About Me


Send me a message