Link to home
Start Free TrialLog in
Avatar of Rozamunda
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
ASKER CERTIFIED SOLUTION
Avatar of momi_sabag
momi_sabag
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
or another approach (which might perform better)

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
SOLUTION
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial