Mike: don't make me stop this car, kids!
Benny_Hill: Got an SQL question for you folks.I have two tables, Student and ScoresStudent+----+------+-------+| id | name | grade |+----+------+-------+| 1 | Bob | 11 || 2 | Mary | 11 || 3 | Tim | 12 || 4 | Lisa | 12 || 5 | Gary | 10 || 6 | Leah | 10 || 7 | Dean | 11 || 8 | Lori | 10 || 9 | Don | 12 |...Score+----+------------+-------+| id | student_id | score |+----+------------+-------+| 1 | 4 | 100 || 2 | 3 | 98 || 3 | 3 | 97 || 4 | 3 | 86 || 5 | 4 | 92 |...I want to list ONLY the top 3 scores for EACH student in grade 12 like so:+------+-------+| name | score |+------+-------+| Tim | 98 || Tim | 97 || Tim | 86 || Lisa | 100 || Lisa | 92 |...What would my SQL statement be?I'm sure it's simple but I've never had to use SQL since I'm an RPG programmer. In RPG I'd just READ a logical file over the Student table that only contained grade 12 students and then do a READE on a logical file over the Score table where the records were sorted by student_id, score desc.
MusicMakeMyHeadPound: SELECT name, grade.score FROM students INNER JOIN grade ON students.id=grade.student_id ORDER BY name, score DESC;Will get you the information you want. Not sure how to limit it to three each by name yet.
No_47: Then I'd suggest virus/spyware/etc scanning the machine, and updating all your drivers before trying to install again.
Mike: what version of mysql?
gayb: Service pack three is raping my xp box right now. It's wonder I can even post on the internets from the goddamned thing before it locks everything up. FARK THIS.I figured I'd let automatic updates tell me when I could get it instead of trying to get it early, but apparently they didn't bother to make it work correctly, ever. If I ever stop gaming, I'll never set e-foot inside a windows box again. *sigh*
Man On Fire: Cedega and Wine.
TehNacho: Wow. I suck.If any of you remember I've been trying to fix this guys computer. I went ahead and made the hard drive one big partition, (it was a small 33 mb partition and then one 55 gb partition) reformatted, and installed XP Home using the disks Dell provided. I figured that it would not do any harm to delete the utility partition, as I figured the malware he had installed had probably found it's way into everything.Now, when I turn on the computer, I am asked to choose between operation systems Windows XP Home or Windows XP Home. I've booted into both and they seem to be the very same. When I go into either it shows that there is 55 gb of remaining space.I pretty much want to make it so that he doesn't have to "choose."What uh, what should I do?
Fenis-Wolf: Right click My Computer, Properties, Advanced tab, Startup and Recovery, then set the Default Operating System to one of the WinXP Home installs, then set the display OS list to 1 or 0.Done.
No_47: I'm not sure if this has been added by an extension I'm using or if it's part of Firefox, but tryRight Click anywhere on page -> Reload Every -> (choose time)Right Click anywhere on page -> Reload Every -> Enableand yeha I think it 404s when you go offline
Barakku: Shiat-my farky's acting up too, speaking of FF extentions, any idea why farky 1.11 would be hiding random threads? I have no filters set up...
Barakku: No_47: I'm not sure if this has been added by an extension I'm using or if it's part of Firefox, but tryRight Click anywhere on page -> Reload Every -> (choose time)Right Click anywhere on page -> Reload Every -> Enableand yeha I think it 404s when you go offlineSounds like what I need, but not a default part of firefox-any idea what extension that might be?
Befuddled: My desktop went pop, a capacitor gave way from what I can see (one is bulged with liquid coming out). Does anyone know if I can just build a new PC and plug my old HD in and have it boot up? Or will the NTSF file system have a cow if it sees a new MB and CPU?
AesopRock_00: the Reload Every Firefox plugin.
No_47: Also, referring to another question, I've found that NT-based windows rarely boots with a new motherboard. Even if a machine is running and you uninstall all the drivers first. It just bluescreens and there's no way to fix it.
Mike: 0x0000007B = INACCESSIBLE_BOOT_DEVICE :)
Mike: Depends on how slow they want the page to load, and if they reeeeeally wanna use Photoshop to edit all their text vs using a text editor like everyone else...
No_47: I've got a pc here that memtest failed on after 8 hours and 7 passes... with a "unexpected interrupt" "type: divide"I don't really have any choice but to swap out hardware and run it for another 8 hours, do i?
nosajghoul: Anyway, the question : How are these people finding their stolen laptops over the internet? Unless you set up something that did something like automatically emailed yourself once a day, how would you get it back?
nosajghoul: How are these people finding their stolen laptops over the internet?
Links are submitted by members of the Fark community.
When community members submit a link, they also write a custom headline for the story.
Other Farkers comment on the links. This is the number of comments. Click here to read them.
You need to create an account to submit links or post comments.
Click here to submit a link.
Also on Fark
Submit a Link »
Copyright © 1999 - 2017 Fark, Inc | Last updated: Aug 23 2017 19:31:06
Runtime: 2.333 sec