|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
SQL query
hello there.
can someone please help im stuck!! i have 2 lists of numbers which have exactly the same numbers in them apart from a few. i need a query to find them few and wondered if anyone could help! i suppose it would be the opposite of finding duplicates!!! thanks for your help in advance! |
|
#2
|
|||
|
|||
|
Code:
select * from list1 where numericValue not in ( select numericValue from list2) |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > SQL query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|