SQL question: Getting all records based on a row-specific criteria [more inside]
posted by 0xFCAF on Jul 26, 2009 - 6 answers

I have a basic sql query which returns all jobs run between specified dates as follows: SELECT job_id, starttime, size FROM job_history WHERE (starttime > FromDate) AND (startTime < ToDate) But I also want the query to return the previous size for that job_id [more inside]
posted by xla76 on Jul 23, 2009 - 4 answers

I need to write a query that will return the largest value of one column for each unique value in another column. Example included. [more inside]
posted by davcoo on Jul 17, 2009 - 2 answers

Oracle Views: Are calculated columns always evaluated even when they are not considered in a query? [more inside]
posted by NailsTheCat on Apr 21, 2009 - 7 answers

I have a (hopefully easy) SQL question. I'm working in MS Access. Simplifying things a bit, I have a table with a TaskID, and a TaskStatusID. I want to get a list of each TaskID, and the newest TaskStatusID for each. (Details follow.) [more inside]
posted by inigo2 on Apr 21, 2009 - 7 answers

How can I get the IN function to work in my SQL? [more inside]
posted by urbanwhaleshark on Feb 19, 2009 - 12 answers

Can I specify the order in an ORDER BY clause in a SQL Statement? If not then what is the best way of doing the following query? [more inside]
posted by xetere on Feb 19, 2009 - 9 answers

How can I update whole columns in a sql database using new information from an excel spreadsheet while using a Mac? [more inside]
posted by visual mechanic on Feb 16, 2009 - 5 answers

Microsoft Access query problem - Comparing two similar tables that don't match up well. It's lists of classes in a collection of locations from two consecutive years, and what I need is to show the class fees side by side for any class that happened in the same location both years. [more inside]
posted by dnash on Feb 5, 2009 - 13 answers

Can anyone give me advice on dealing with checkboxes in PHP, to hand off to SQL. [more inside]
posted by opsin on Jan 30, 2009 - 8 answers

Please help me find the T-SQL that removes duplicate spaces within a string (or suggest your own method). [more inside]
posted by DakotaPaul on Dec 17, 2008 - 2 answers

I have a MySQL table with about 100,000 items in it. Question about setting up indexes for efficient querying. [more inside]
posted by maxwelton on Oct 15, 2008 - 8 answers

SQL/MS Visual Studio help please! I have two tables. I need to present Table1 data grouped by SiteID, within time FROM and TO, on the report. Then I need to make one calculation on the report using Table 1 data totalled across all sites (and within FROM and TO) plus Table 2 data totalled between times FROM and TO. [more inside]
posted by inigo2 on Sep 10, 2008 - 10 answers

What is the "state of the art" with respect to Python on Windows for Active Directory administration and interfacing with MS-SQL 2000/2005/2008? [more inside]
posted by adipocere on Apr 2, 2008 - 7 answers