Questions tagged [maxdate]
143 questions
-1
votes
2 answers
MariaDB: Select val_1, max(value_2), group by value_3
I have the following columns:
| order_id | client_id | order_timestamp | buyer_id | (all INTs)
It started with the easy-sounding task "Show me the buyer of the last order for each client", so basically
SELECT
client_id,
…
Karl
- 9
-1
votes
3 answers
SQL DB2 Max Date Needed for Date Generated with exception
I have payments data and I need to find latest date for payment which is 'Normal', so it cant be Fee or Fee pay and I am stuck. Could you please assist? so in this case I need data to bring me '12-07-2018' only as this is the latest normal payments.…
marijapt
- 13
- 5
-1
votes
1 answer
Getting NULL Value out of Max(Date) if no Data exists in joined table
I want to see the latest approval date (V.Datum) of a certain item (BauteilID) coming from a distinct supplier (m.Lieferanz_FreigabeID).
If there is not any approval date in the table related to a supplier, it should return NULL. Instead I get the…
EricQ
- 15
- 3
-1
votes
1 answer
How to find MAX(date) from BETWEEN(dates) in column 2 with DUPLICATES in column 1?
I have a Database that has product names in column 1 and product release dates in column 2. I want to find 'old' products by their release date. However, I'm only interested in finding 'old' products that released a minimum of 1 year ago. I cannot…
John Miller
- 1
- 2
-1
votes
2 answers
SQL Select latest result from table where keyword = and competitor =
I have two tables as such:
tablename: input_keywords
Cols: keyword, last_check, pages_deep, check_freq_days
tablename: rank_result
Cols: keyword, result_url, position, last_check, competitor
input_keywords.keyword is unique, so that we don't look…
Alex Hellier
- 435
- 1
- 7
- 15
-2
votes
1 answer
MySQL_Retrieving stock price based on max and min_date
I am trying to retrieve closed and opened stock prices from the first and last date per month.
For some reason, the output of the 'end_date_closed_stock_price' is NULL.
Do you know any idea why it is giving this result?
Also, could you tell me the…
DanielJin
- 1
- 1
-2
votes
2 answers
How can I restrict dates to some number of days from some date?
I would like to ask how to restrict the mindate/maxdate from a selected date.
For example, I have two datepicker, picker_A and picker_B.
I selected 2020/01/29 in picker_A. Then, I need to restrict the date range in picker_B to allow only 10 days…
Tommy Mok
- 91
- 10
-2
votes
1 answer
MAX DATE with Multiple tables/Inner Joins in Toad/Oracle
I have only been using Toad/Oracle for a few weeks so am still learning coding etc I have knowledge of SQL Code in Access and trying to now learn Oracle.
I need to return the max date from UCMRBILDAT from tbl BIC/AZUCDMO0100 but only from contracts…
Lee Hudspeth
- 1
- 6