File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SqlHelp" Watch "SqlHelp" New topic
Author

SqlHelp

Anonymous
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
Marshal

Joined: May 26, 2003
Posts: 29244
    
139

Shan,
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
Anonymous
Ranch Hand

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