On 03/09/2016 01:38 PM, Alex Hall wrote:
Hi all, I want to select * from a table, getting all columns. However, the only rows I want are where the item number is distinct. I've got: items = session.query(itemTable)\ .distinct()\ .limit(10) But that doesn't apply "distinct" to just item_number. I'm not the best with SQL in general or I'd express the query I want so you could see it. Hopefully my explanation is clear enough.
as mentioned here you can send ItemTable.item_number to the distinct() function, but to my knowledge the "SELECT DISTINCT(x, y, z).." syntax only works on Postgresql.
After my fighting with the iSeries here at work a few weeks ago, I set up SA to access a Microsoft SQL database yesterday... In about two hours. That includes setting up the DSN, getting the database name wrong, getting the credentials wrong, and other non-SA problems. With all that, SA itself was a breeze. It's amazing what happens when you don't try to use IBM machines in the mix. :)
-- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
