File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes SqlHelp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SqlHelp" Watch "SqlHelp" New topic


Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Dno Status
10 null
10 aa
20 null
20 bb
20 cc
30 null

Display REcord that has a null status but has only one record.

output 30 null
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30050

You need to use a subquery. It is something like this:

select * from table t1
where t1.status is null and 1 =
(select count(*) from table t2 where t1.dno = t2.dno)
[ October 22, 2004: Message edited by: Jeanne Boyarsky ]

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I agree. Here's the link:
subject: SqlHelp
Similar Threads
another array problem
how to get the oldest timestamp record in an array list
what is the meaning of socket write error
IllegalArgumentException when using clj-record's create function
Clarifications on session attribute