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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: bubbisthedog
- Content: Threads
- Order by date
-
WHERE *field* = '%/%'...
Hello, all. Great forum. I'm querying a DB2 table, trying to filter records according to whether or not the, let's say, 'field' value, contains a forward slash (/). I've tried WHERE *field* = '%\/\%' using the backslash (\) to escape the (/) to no avail (records returned are 0). Could...- bubbisthedog
- Thread
- Replies: 2
- Forum: ANSI_SQL
-
Calculating Percent of Total...
Hello, all. I'd like the values in ColB to reflect the ColA values divided by the summation of the values in ColA: ColA | ColB 3 | 3/21 5 | 5/21 6 | 6/21 7 | 7/21 I can't figure this one out, and I haven't had any luck finding a solution by searching the Web...- bubbisthedog
- Thread
- Replies: 2
- Forum: ANSI_SQL
-
GROUP BY, Two Tables: One Unique, One Not...
Hello, all. First post. Following are my table structures ("*" indicates primary keys): TA: EM_ID*, FNAME, LNAME (unique entries) TB: EM_ID, DP_ID, SDATE (not unique entries) TC: DP_ID*, DESC (unique entries) As you can see, TB is my intermediate table, and can include...- bubbisthedog
- Thread
- Replies: 2
- Forum: ANSI_SQL
