Search results for query: *

johpje = genius You rock man :)

Multiple rows, not duplicate rows. Pretty much what I'm trying to do is pull the row containing the latest PrefChangeDate for each unique OracleID.

Tried that.. still returned more rows than I want :(

Well, guess I need to find a new way to go about getting this data since I can only use GROUP BY for up to 10 columns :(

Using this Query: SELECT OracleID, FirstName+" "+LastName AS Name, Max([PrefChangeDate]) AS LastPrefChange, Client, TM, Extention, HireDate, Termed, TermDate FROM AgentPrefs WHERE PrefChangeDate Is Not Null GROUP BY OracleID, FirstName, LastName, Client, TM, Extention, HireDate...

I added that, didn't seem to make a difference :(

I had XP and RedHat 7.2 both installed on my Laptop not too long ago. I've also fooled around with installing RedHat on my desktop machine with XP. If your going to run XP / Linux dual booting, it's probably best to use the Grub bootloader. XP doesn't like Lilo for some reason.

There is really no one difference between the rows that would cause it to pull them. After 10 columns added to the group by, it pulls one, if I had all the columns I want to pull, it ends up pulling all rows where PrefChangeDate != Null. I'm thinking of restructuring the database to maybe make...

Hrm, one thing I just noticed. Once I go over 10 columns pulled from the table, that query no longer works, it starts pulling extra records.. My exact SELECT statement: SELECT OracleID, FirstName+" "+LastName AS Name, Max([PrefChangeDate]) AS LastPrefChange, Client, TM, Extention...

Nevermind, I got it. Thanks a ton! :)

Oops, forgot to mention I don't want duplicates. I only want the first record.

Ok, I've been trying for a couple days to get this query to work work. Here's an example of the data I'm working with: ID | FirstName | LastName | LastUpdate ---------------------------------------------------- 999 | John | Doe | <null> 9999| Jane | Doe | <null> 999 | John | Doe |...