I need to find a way to compare the nth row of data to (n-1)th row or nth row to (n+1)th row in Rapid SQL

Asked Sep 03 '22 at 04:50

Active Sep 04 '22 at 15:05

Viewed 49 times

I need to find a way to compare last row of data to the previous row or the 1st row data to the 2nd row so as to select specific data that have same values in the rows, in Rapid SQL.

My table looks like this..

ID.	ACTION	FEEDBACK	LANGUAGE
112211	AA	ERROR	ABC
112211	AA	ERROR	ABC
112211	AB	ERROR	ABC
112222	AB	ERROR	ABC
112222	AA	ERROR	ABC
112222	AB	ERROR	ABC

Output should be like:

ID		Action		Feedback		Language
112211		AA		ERROR		ABC
112222		AB		ERROR		ABC

edited Sep 04 '22 at 15:05

NickW

8,430
2
6
19

asked Sep 03 '22 at 04:50

Yogz

Does Rapid SQL have the concept of ROW_NUMBER() …? – Skin Sep 03 '22 at 05:03
I am new to this rapid sql, let me check about ROW_NUMBER() – Yogz Sep 03 '22 at 05:58
What is the order of your output? Is it by id and then by action? Ideally you would need a column or combination of columns which uniquely identify any row. Then it can be done with a join (in standard SQL at least it can) – El Ronnoco Sep 03 '22 at 06:01
If you can use row_number() you can get the current row number and minus 1 to get the previous. – Skin Sep 03 '22 at 07:54
@Skin there's no concept of row_number() in Rapid SQL – Yogz Sep 06 '22 at 04:50
Bugger! That would've made life easier. – Skin Sep 06 '22 at 05:01

I need to find a way to compare the nth row of data to (n-1)th row or nth row to (n+1)th row in Rapid SQL

0 Answers0