I need to create an id-column: on every TRUE statement it should be a normal serial number, but on every FALSE statement the field value should contain the previous number in this column. In other words, every FALSE should repeat…
I'm trying to get the maximum value of calories consumed per day. I can't figure out how to get a query result which I imagine to just be 1 row for each date, with a column containing the value for…
In SQL I'm looking for a potential function which I can use to apply a row number each time a certain criteria is met. Each time the Unique ID is the same (i.e. same person) and the Dep_Group is WES…
I'm trying to put sequence id which should start from current date then backwards and should only limit up until 5 rows. I can't do by date as there are times there are missing date row so I still have…
is there any way to implement top 1 result from each group without using ROW_NUMBER? table_a below has already 1 billion rows, so I want to use the most efficient way. And the below query is what I'm using. SELECT…
I have a need to get the max number of records from a table and concatenate that number at the end of the field name, starting at 1 and ending at the max number of records: field1 cnt Car 4…
I'm trying to group rows when it starts with 1 and has consecutive 0s, and stop grouping once it meets another 1 or 2. Here is an example: (column 'group' is what I expect to see) +-----+------+-------+ | seq |…
I need to regenerate all primary key numbers from zero and keep previous amount in ex column but the query doesnt work : update mh_product AS p,(select p.id AS oldid,row_number() OVER (order by p.id asc)-1 AS newid from p) AS…
row_number query question. To get the data where rn is 1, you can wrap the query below and import it with where rn = 1. Is there a way to get only those whose rn is 1 in the current…
I have an unusual problem I'm trying to solve with SQL where I need to generate sequential numbers for partitioned rows but override specific numbers with values from the data, while not breaking the sequence (unless the override causes a…