Re: Finding Rank of score and range of scores
I am not having much luck with the information listed there.
Here is my php segment issuing this query.
No records are returned,.
$sql = "SELECT uo.*, (SELECT COUNT(*) FROM {$Account} ui WHERE (ui.Score * 1) > (uo.Score * 1) AND School_Name = :School_Name AND Class_Name = :Class_Name AS rank) FROM {$Account} uo WHERE School_Name = :School_Name AND Student_Name = :Student_Name AND Class_Name = :Class_Name";
$stmt = $dbh->prepare($sql);
$stmt->execute(array('School_Name' => $School_Name, 'Student_Name' => $Student_Name, 'Class_Name' => $Class_Name));
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$result = $stmt->fetchAll();
Subject
Written By
Posted
Re: Finding Rank of score and range of scores
July 08, 2016 06:50PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.