Для этого вы можете использовать функцию ROW_NUMBER()
, например :
SELECT
ID
, LeaseDate
, InvoiceDate
, StartDate
FROM
(
SELECT
L.ID
, L.LeaseDate
, I.InvoiceDate
, I.StartDate
, ROW_NUMBER() OVER (PARTITION BY L.ID ORDER BY I.StartDate) R
FROM
Leases L
JOIN LeaseInvoices I ON L.ID = I.LeaseID
) Q
WHERE
R = 1
AND LeaseDate <> InvoiceDate
glGenerateMipmapOES (GL_TEXTURE_2D);
документ http://www.khronos.org/opengles/sdk/docs/man/glGenerateMipmap.xml