Home » SQL & PL/SQL » SQL & PL/SQL » Display records not having particular code
Display records not having particular code [message #255877] Thu, 02 August 2007 04:31 Go to next message
Messages: 211
Registered: July 2004
Senior Member
Hi Experts,

I have a table with columns ID,TAG_NO,TAG_DATE,CODE. In this table the ID and CODE are unique.

for example
id tag_no tag_date code
1 ROO1 23-APR-07 T101
2 R001 23-APR-07 T102
3 R001 23-APR-07 T103
4 R001 23-APR-07 Z300
5 R002 23-APR-07 T101
6 R002 23-APR-07 T102
7 R003 23-APR-07 T101
8 R004 23-APR-07 T103
9 R004 23-APR-07 J101
10 R004 23-APR-07 J102
11 R005 23-APR-07 Z300

From this table I want to dislay only the tag_no don't have the code Z300.

I used the script like this

Select tag_no,tag_date from x where code != 'Z300' but it was displaying all the tag_no but I want my output like this be


Since R002 and R005 has used the code Z300. Can anyone help please?

Re: Display records not having particular code [message #255880 is a reply to message #255877] Thu, 02 August 2007 04:45 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For instance,
select tag_no from mytable where tag_no not in (select tag_no from mytable where code='Z300')

Previous Topic: To get no. of working days in a month using a query
Next Topic: dept of max emp
Goto Forum:

Current Time: Sat Aug 19 17:36:00 CDT 2017

Total time taken to generate the page: 0.11906 seconds