Join 3,368 readers in helping fund MetaFilter (Hide)

2 posts tagged with sql by Nothing.
Displaying 1 through 2 of 2.

Related tags:
+ (76)
+ (42)
+ (42)
+ (34)
+ (27)
+ (16)
+ (16)
+ (16)
+ (12)
+ (12)
+ (9)
+ (9)
+ (8)
+ (8)
+ (7)
+ (6)
+ (6)
+ (5)
+ (5)
+ (5)
+ (5)
+ (5)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)


Users that often use this tag:
desjardins (6)
DakotaPaul (6)
odinsdream (6)
iamkimiam (3)
arrowhead (3)
inigo2 (3)
mark7570 (2)
Anonymous (2)
jfricke (2)
dnash (2)
Four Flavors (2)
bleucube (2)
Wild_Eep (2)
apark (2)
maxwelton (2)
AllesKlar (2)
omnipotentq (2)
Just this guy, y'know (2)
benjh (2)
Glendale (2)
Jimbob (2)
Nothing (2)
Dr Dracator (2)
derbs (2)
adipocere (2)
eas98 (2)

SQL Query Question

SQL query help. Given the (fictional but equivalent) table disk_status = computer_id:int, disk_id:int, datetime:datetime, temperature:float, rpm:int, I need to provide a table of disk status for a given computer_id, without knowing in advance how many disks there are. So if there were two disks for a particular computer, the result would have the header: datetime, disk_1_temperature, disk_1_rpm, disk_2_temperature, disk_2_rpm, disk_2_rpm [more inside]
posted by Nothing on Apr 16, 2009 - 25 answers

mysql query help please

MySQL question: Given a table with a datetime column and several additional columns which may or may not be null, is there an easy way to select the most recent previous non-null value of each column given a specific date? [more inside]
posted by Nothing on Mar 13, 2008 - 10 answers

Page: 1