nozzy

UPDATE users set rank = (%s), pin = (%s) where teleid=(%s)

select 
t1.AUTHOR,
t1.total
from
(
SELECT AUTHOR, count(*) as total
FROM POSSESSION
INNER JOIN BOOKS ON BOOK_ID = BOOKS.ID
WHERE TAKING_DATE > (CURRENT_DATE - INTERVAL '1 year')
GROUP BY AUTHOR
)  t1
where t1.total =
(
select
max(t2.total)
from
(
SELECT AUTHOR, count(*) as total
FROM POSSESSION
INNER JOIN BOOKS ON BOOK_ID = BOOKS.ID
WHERE TAKING_DATE > (CURRENT_DATE - INTERVAL '1 year')
GROUP BY AUTHOR
) t2
)

select
*,
ROW_NUMBER() OVER (PARTITION BY ForeignKey ORDER BY Datetime DESC) as RowNum 
from table
where RowNum = 1

select
t1.*,
t2.*,
t3.*
from mainTable t1
inner join mainTable_table1 t2 on t2.id_mainTable = t1.id_mainTable 
inner join table1 t3 on t3.id_table1 = t2.id_table1