Need to return all rows but one.

realstandman · Mar 7, 2006

I need to return all rows in the table clmdes1 except for row 167063 and 167064. How can this be done?

PHV · Mar 7, 2006

Something like this ?
SELECT * FROM clmdes1 WHERE yourRowIdField NOT IN (167063, 167064)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Need to return all rows but one.

realstandman

IS-IT--Management

PHV

MIS

Similar threads

Part and Inventory Search

Sponsor