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!
Search results for query: *
- Users: vengelus82
- Content: Threads
- Order by date
-
lost in querying
Dear all, this is my following problem: 28035,"104" 28035,"31" 28035,"39" 28035,"75" 28035,"2" 28035,"86" 28035,"44" 28035,"84" 28035,"98" 476,"1" 476,"76" 476,"40" 476,"31" 476,"102" 476,"93" 476,"53" 476,"83" 476,"96" 6697,"76" 6697,"1" 6697,"41" 6697,"32" 6697,"102" 6697,"94" 6697,"83"...- vengelus82
- Thread
- Replies: 7
- Forum: ANSI_SQL
-
sum case when
Hi guys, I am having problem to add additional condition(s) to my SQL statement in PHP This is the following SQL statement: SELECT EXTRACT(YEAR FROM users.date) AS Year, SUM(CASE WHEN table_gender.profile_id = 1 THEN 1 ELSE 0 END) AS "Men", SUM(CASE WHEN table_gender.profile_id =...- vengelus82
- Thread
- Replies: 0
- Forum: PHP
-
Rescue this newbie
Hi Guys, I am using SQL to categorize certain data. 28035 104 28035 30 28035 39 28035 75 28035 2 28035 86 28035 44 28035 84 28035 98 476 1 476 76 476 40 476 30 476 102 476 93 476 53 476 83 476 96 6697 76 6697 1 6697 41 6697 30 6697 102 6697 94 6697 83 6697 96 I want to select cells from the...- vengelus82
- Thread
- Replies: 21
- Forum: ANSI_SQL
