View previous topic :: View next topic
|
Author |
Message |
ksathishkumar4u Currently Banned New User
Joined: 29 May 2006 Posts: 0
|
|
|
|
Select * from <<Table Name>> where << condition1>> and not <<Condition2>>
what is the meaning of not <<condition2>> |
|
Back to top |
|
|
SBMF390
New User
Joined: 27 Jul 2006 Posts: 9
|
|
|
|
Hi,
Select * from TAble1 Where ay = '12' and Not = '67'
Hope u can get it. |
|
Back to top |
|
|
muthuvel
Active User
Joined: 29 Nov 2005 Posts: 217 Location: Canada
|
|
|
|
Hi,
Use the NOT keyword to select all rows except the rows identified with the search condition
The NOT keyword must precede the search condition
Example-
SELECT EMP_NO, EMP_NAME, DT_JOIN
FROM EMP
WHERE NOT WORKDEPT = ?OS'
In this case the rows which do not have Work Department as 'OS' will be retrieved.
Thanks,
Muthuvel. |
|
Back to top |
|
|
|