Help with MySQL Questions
11 USD I want to get the maximum value (by date) from the table.
I have such a request:
SELECT company_id, plan_id, created_at
From the company_plans
WHERE created_at in (
Select Max (created_at)
From the company_plans
Group by company_id
( The
AND company_id = 59864
I get 2 rows in the table. I want the idea is to get only a removed line.
Client's review of cooperation with Oleg V.
Help with MySQL QuestionsThe task is performed quickly and efficiently. I recommend it!
Freelancer's review of cooperation with Oleksandr B.
Help with MySQL QuestionsA great customer, I recommend.
-
1 day11 USD
100 1 day11 USD
Write the first SELECT word distinct.
And select GROUP BY company_id, it will take
-
1 day11 USD
3650 257 0 1 1 day11 USD
Hello to
turn to
One request
+ + + + + + + + +
-
1 day11 USD
591 22 0 1 day11 USD
I'm going to make a few questions that will get the last record. Choose yourself to benefit.
-
1 day11 USD
928 22 0 1 day11 USD
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. )
-
Winning proposal1 day11 USD
530 32 4 Winning proposal1 day11 USD
I will perform.
• • • • • • • • •
-
SELECT 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
-
Дякую, але на жаль це рішення не підійде. Я показав на прикладі однієї company_id, а на справді їх більше
-
Если у Вас несколько записей за одну дату, хотите получить тот, у которого id больший?
-
Хочу отримати, саме максимальний по даті. Бо вона у форматі до секунди (2022-01-11 13:19:27). Але так як id створюються по черзі, то можна і по більшому id
-
Это неверно. В самом запросе выбирается максимальная дата и после отбираются все записи за эту дату. Сейчас их там 2, но может быть и больше. Лимит не поможет
-
SELECT 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
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 2 days 1 hour back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 2 days 19 hours back ∙ 9 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 3 days 12 hours back ∙ 90 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 3 days 15 hours back ∙ 16 proposals |
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 5 days 13 hours back ∙ 6 proposals |
Kyiv