Budget: 500 UAH Deadline: 1 day
Write the first SELECT word distinct.
And select GROUP BY company_id, it will take
Budget: 500 UAH Deadline: 1 day
Hello to
turn to
One request
+ + + + + + + + +
Budget: 500 UAH Deadline: 1 day
I'm going to make a few questions that will get the last record. Choose yourself to benefit.
Budget: 500 UAH Deadline: 1 day
Good day .
Get ready to help, consult on different types of requests, optimization of requests, and in general on working with BD.
Great experience in working with various BDs.
The PS. Examples in discussions are not very reasonable. )
Oleg V.
Winning proposal- Projects 36
- Rating -
- Rating 506
Budget: 500 UAH Deadline: 1 day
I will perform.
• • • • • • • • •
Proposals are currently absent
-
V V 26 September 2022SELECT company_id, plan_id, created_at
FROM company_plans
WHERE created_at IN (
SELECT MAX(created_at)
FROM company_plans
GROUP BY company_id
)
AND company_id = 59864
ORDER BY 2 DESC
LIMIT 1
-
Oleksandr B.
26 September 2022
Дякую, але на жаль це рішення не підійде. Я показав на прикладі однієї company_id, а на справді їх більше
-
Oleg V. 26 September 2022Если у Вас несколько записей за одну дату, хотите получить тот, у которого id больший?
-
Oleksandr B.
26 September 2022
Хочу отримати, саме максимальний по даті. Бо вона у форматі до секунди (2022-01-11 13:19:27). Але так як id створюються по черзі, то можна і по більшому id
-
Oleg V. 26 September 2022Это неверно. В самом запросе выбирается максимальная дата и после отбираются все записи за эту дату. Сейчас их там 2, но может быть и больше. Лимит не поможет
-
Aleksey Maslov 26 September 2022SELECT company_id, plan_id, created_at
FROM company_plans
WHERE created_at IN (
SELECT MAX(created_at)
FROM company_plans
GROUP BY company_id
)
AND company_id = 59864
ORDER BY created_at DESC
LIMIT 1
Вони не зрозуміли 2.
Current freelance projects in the category Databases & SQL
-
Not specified
Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service
Gaming Apps 9 proposals 11:47
-
Not specified
Development of the CRM module "Requests" in custom 1C (bus center)
Client Management & CRM 19 proposals 31 July
-
22 USD
Support for Samotur and its servers
17 proposals 27 July
-
179 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities
Client Management & CRM 41 proposals 27 July
-
Not specified
Development of an analytical system with a dashboard
Enterprise Resource Planning (ERP) 43 proposals 20 July