I have a door access control system saving events into an Oracle database. The system logs door access (proximity card reads) in a table like the following:

I have a door access control system saving events into an Oracle database. The system logs door access (proximity card reads) in a table like the following:

I have a door access control system saving events into an Oracle database. The system logs door access (proximity card reads) in a table like the following:

I have 2 tables table_A and table_B with the below structure:

I have 2 tables table_A and table_B with the below structure:

How can I select all test names in one row instead of multiple row in oracle SQL if these tests belongs to one sample_id ?

How can I select all test names in one row instead of multiple row in oracle SQL if these tests belongs to one sample_id ?

I am having difficulty in writing one SQL query. The need I have is with in a group of rows I have to assign a sequence for each row for which I can simply use rank to write my query.
However, I need to also use the lower limit and upper limit of the sequence number and if the upper limit is crossed, I have to start again from lower limit.

Closed 2 days ago.

Closed 2 days ago.