Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Count / group by
Hi there, Another plain SQL question. I have data that holds entity relationships across years. From it I'd like to know which values of Entity2 have only ever been related to a single Entity1 regardless of the year. Data looks like the following... Entity1 Entity2 Year 443 444... -
Collapsing results to a single row.
Hello, Question about formatting my query results. I have a customer table and a customer_phone table linked by customer_id field. When I select records from customer_phone for a particular customer_id I get as many rows as the customer has phone numbers. For example select * from... -
SQL remove repeating rows
Hello, I have an issue with SQL and I just cant seem to figure out the approach to achieve the result I need.... I have the following record set and I am wondering how I can remove certain rows. C1[tab]C2[tab]C3[tab][tab]C4 A[tab]B[tab][tab]C[tab][tab]1 A[tab]C[tab][tab]C[tab][tab]2... -
General SQL question - set operations
Hello, I am fairly new to SQL and have a question that I'd like to pose. I have a list of IDs an I would like to find which IDs in that list do not exist in a particular table. It is simple to find the ones that exist in the table, but I am not sure how to go the other way. For example say I...- stiley
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
-
Odd behaviour with CVS
Hi there, I am not new to ant but have never seen the functionality it is now exhibiting, and I am confused I have a build file with 3 main targets. Target 1 functional-test: Gets all files based on branches from cvs and compiles and composes an EAR and WAR file for deployment as well, zips...- stiley
- Thread
- Replies: 1
- Forum: Apache: Jakarta
