Re: [SQL] Lowest 2 items per

2012-06-02 Thread msi77
A few of approaches to solve this problem: http://sql-ex.com/help/select16.php 01.06.2012, 18:34, "Relyea, Mike" : > I need a little help putting together a query.  I have the tables listed > below and I need to return the lowest two consumables (ranked by cost > divided by yield) per printer, pe

Re: [SQL] Lowest 2 items per

2012-06-02 Thread Oliveiros
Nice resource, msi77. Thanx for sharing. I wasn't aware of none of these techniques, actually, so I tried to start from scratch, but I should've realized that many people in the past had the same problem as Mike and I should have googled a little instead of trying to re-invent the wheel. Anyway,

Re: [SQL] Lowest 2 items per

2012-06-02 Thread msi77
Thank you for reply, Oliver. I want that you'll pay attention to the learn exercises which can by made under PostgreSQL among few other DBMS: http://sql-ex.ru/exercises/index.php?act=learn 02.06.2012, 19:00, "Oliveiros" : > Nice resource, msi77. > > Thanx for sharing. > > I wasn't aware of none