From: jsWalter <jsW...@to...> - 2007-10-12 19:04:15
|
> So you're selecting the rows for each date and line_num that have (or > tie for) the highest line_num and seq_num. > > You don't mention whether cel_num or seq_num has higher priority. > Which of these two rows would be selected? > > ID DATE line_num seq_num cell_num time > 1 APM 2007-10-02 2 0 1 6.00 > 2 APM 2007-10-02 2 1 0 5.50 Sorry, #2 has the higher priority. walter |