Questions about partition
Read more about partition
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
How to automate partition drop and alter table activity in oracle sql developer
I need a procedure that will help me to drop partition older than 3 months (current month + last 3 older months). And then I need to create the new partition in sequence.
for example if current partit...
Deepika Sheldar
Votes: 0
Answers: 2
AWS Athena MSCK REPAIR TABLE "table_name" Error adding new partitions
When trying to refresh the partitions in a AWS Athena/Glue table I am getting this error
line 1:1: mismatched input 'MSCK'. Expecting: 'ALTER', 'ANALYZE',
'CALL', 'COMMIT', 'CREATE', 'DEALLOCATE', 'D...
Eduardo Rodrigues
Votes: 0
Answers: 2
RANK function doesn't work on CTE table in posgresql?
I'm trying to rank my CTE table (a) output based on reviews and partition by two columns (risk_full_nm and exam_year_nb).
Below is my code:
\`WITH a AS
(
select rr.risk_full_nm ,e.exam_year_nb,COUNT(D...
Lukas
Votes: 0
Answers: 1
SQL - SQL Server 2019: Group rows with that are less than 14 days apart and return the 1 row of each group
I have a tablelike this:
If t1_view_dt are within 14 days of each other, I need to show the 1st row of each group in another column named t2_view_dt.
+------------+------+------------+------------+---...
daniellerobinson7836
Votes: 0
Answers: 1