Hi,

Can you check this is working or not? This is Oracle Syntax and should fulfill the second column requirement

select * from

(select a.*, count(*) over (partition by examid) attempt

,row_number( )...

Hi,

Can you check this is working or not? This is Oracle Syntax

select * from

(select a.*, count(*) over (partition by examid) attempt

,row_number( ) over (partition by examid order by studentid,examid,attemptfk)...

This should work for the first column requirement:

SELECT *

FROM student_mark1 STU_MAIN

WHERE attemptfk = ( select case when ((select count(1) from student_mark1 where studentid = STU_MAIN.studentid and examid =...

Hi,

To get the max score if the attempts or 3 or more, can you run the following query and check it:

select *

from student_mark1 STU_MAIN

where

attemptfk =...