Rozamunda
asked on
SQL question
I have a file keyed by isbn13
lang code and isbn are attribute fields,
now I want to select those isbn13 who have the same isbn but different language code
lang code and isbn are attribute fields,
now I want to select those isbn13 who have the same isbn but different language code
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select t1.isbn13
from your_table t1 join your_table t2
on t1.isbn13 = t2.isbn13
and t1.isbn = t2.isbn
and t1.language_code > t2.language_code