Manning's Countdown to 2014
. Use discount code crdotd14 all month for 50% off every deal.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Merging 2 results into one select :shock:
Joined: Apr 06, 2008
Mar 09, 2009 13:19:14
I would like this result:
SELECT MAX(tagdate) as lastdate FROM JPASSETTAGS where TAGNAME = 'NY'
to be with in the same result as:
SELECT t.TAGNAME,pubid,COUNT(*) as count FROM JPASSETTAGS t,ASSETPUBLICATION a where a.ASSETID = t.ASSETID GROUP BY t.TAGNAME,pubid ORDER BY 3 DESC
table JPASSETTAGS has the column tagdate, tagname, assetid
table ASSETPUBLICATION has the column pubid, assetid
I agree. Here's the link:
subject: Merging 2 results into one select :shock:
Join condition qucik question
Counting identical items in DB
how to execute sqlplus and sql commands using java
SQL: Retrieve duplicate records
unable to get column values
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013