Posts by Milky-way • 513 points
2 posts
-
32
votes5
answers41630
viewsQ: Mysql Limit Equivalent in SQL Server
Someone knows how to relate the differences between Mysql and SQL Server, including using LIMIT n,n? Or if you have a link that lists the differences would be nice. Example SELECT * FROM tabela…
-
6
votes5
answers29249
viewsQ: How to calculate age based on DATE of birth in Mysql based on month and day?
I have the appointment below, but she ignores the month and day of birth SELECT FLOOR(DATEDIFF(NOW(), c.nascimento) / 365) AS idade FROM clientes c In the result, most come right, but sometimes have…