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 Chriss Miller 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: sorkIndustries
- Content: Threads
- Order by date
-
how do I structure this query?
My table has the following columns: A boolean,B integer,C varchar(40) I want to get a count of the true and false values in A for each combination of B and C, and the percentage of true values. For example, if the table has the following values: A B C true 35 bob false 35 bob...- sorkIndustries
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
SQLite question
Hi, I'm posting in General because I didn't see a specific forum for SQLite. Here's my question: I am having difficulty using SQLite. I have a table, let's say it's called Inventory and its fields are Product and Store, like this: Product+Store ---------|--------- Pen | Bookstore Soda...- sorkIndustries
- Thread
- Replies: 6
- Forum: -General database discussion
-
using GROUP BY to find percentages
In table UserInfo, I have three fields: Users, Requests, and Approvals. For each user, I want to find the percentage of requests that are approved. Here is some sample data: User|Request|Approval ----+---------+-------- A Y Y B N N C Y N A N...- sorkIndustries
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
