Hello, I was wondering if anyone could explain how to approach
this scenario.
I have a table that is built as follows
rowid model_num seq_num desc
==== ========= ======= ====
22 388 7 plate
23 388 8 box
24 125 3 steel
25 388 9 tool
26 388 8 glass
27 125 4 belt
Rowid is unique. No model_num should
have a duplicate sequence number, but
different model_nums can have same seq_num.
In this case row 23 and 26 have the same model_num
and share a seq_num (8). What is the best way to search for
this condition.
Would a query be the best way or would a stored procedure
or block of code work better? I'd say the size of the table is about 100k
rows.
