Distinct - og flere værdier

You cant have an order by on a field which isnt selected

order by charDate

try

Select distinct charName as [Name], level, charDate from Data order by charDate

Tak, smid et svar :D

selv tak

naaa, den returnere stadig alle rækker, skal jeg oprette en ny ?

Vh ?

jeg brugte:


Select distinct charName, charDate from Data order by charDate

naaa fuck det, det er egentligt ligegodt.

Vh

sorry, didnt see your comments, for some reason I'm not receiving mails from eksperten!


Are you still having problems? If so can you give an example of your data and what you expect in the result?

iam at work atm but my table looks like:

[id]  [charName] [charLevel]  [charDate]
1        Jacob            3                      01-01-1900
2        Jacob            4                      01-02-1900
3        Ole                3                    01-02-1900

I need a resultset as:

[id]  [charName] [charLevel]  [charDate]
2      Jacob            4                      01-02-1900
3        Ole              3                    01-02-1900

So all the colums ordered by date, distinct name.

Thx
Jacob.

Ok, I'll take a look later (after work) and put something togther for you.

thx, i can supply u with access db if necessary.

/J

Ok, send to ekspertenATsanthell.dk
AT = @

have you sent me your dB?

on its way m8

Hej Terry.

I have attached the access database as 2007 and 2003.

The data is from a highscore list, i need alle the names distinct and all the other colums as a single row ordered by newest charDate.

My application needs to give me an fast overview about changes on the highscore, so do u know if its possible to make one sql call, and get 2 rows, giving one charName and 2 dates ?

I juse:

SELECT Data.charName, Data.charLevel, Data.charDate
FROM Data
WHERE  (Data.charDate=#1/6/2009 0:0:1# or Data.charDate=#1/6/2009 0:1:0#) and charName = 'Renegade'

But can i in the same SQL statement, take the difference of charBlood from the two dates ?

i have attached a screendumb of my applikation, right now i just take alle the names from the newest date and loop through em all;

string lastSql = "Select * from Data where charName = '"+Name+"' and (((data.charDate)=#"+dtLast.ToString("M/d/yyyy H:m:s")+"#))";
string nowSql = "Select * from Data where charName = '" + Name +"' and (((data.charDate)=#"+dtNow.ToString("M/d/yyyy H:m:s")+"#))";

But the call is very expensive as the database grows, therefore it could be neat if i could get the diffrence in charBlood in the same SQL

Thx in advance.

/Jacob.

"The data is from a highscore list, i need alle the names distinct and all the other colums as a single row ordered by newest charDate."

is the original question giving 200 points, just tell me if i need to make a question more for the other part.

Thx
Jacob.

the questions is, can i with the parameters "charName" and 2x "charDate" get the difference in charBlood in one sql call.

Hi Jacob
What is the status on this question, did we ever find a solution?