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
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "SqlHelp" Watch "SqlHelp" New topic
Author

SqlHelp

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
posted
0
Quote
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: 26173
    
  66

I like...
Eclipse IDE Java VI Editor
posted private message
0
Quote
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
posted
0
Quote
thanx
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SqlHelp
 
Similar Threads
what is the meaning of socket write error
how to get the oldest timestamp record in an array list
another array problem
IllegalArgumentException when using clj-record's create function
Clarifications on session attribute