i don't know how can i select as this

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

hi every one
i have a table as this :

  Date      Shift    IDType  IDPers    Value
2000/1/1    1          1          1          10
2000/1/1    1          1          2          12
2000/1/1    2          1          1           8
2000/1/1    2          1          2          14
2000/1/2    1          1          2           5
2000/1/2    1          2          1          19
2000/1/2    2          1          2          23
2000/1/2    2          2          1          28

now,i want select last inserted every IDPers as this :

  Date      Shift    IDType  IDPers    Value
2000/1/1    2          1          1           8
2000/1/2    2          1          2          23
2000/1/2    2          2          1          28

but how can i select as above
thank you

Posted 26-Mar-12 22:34pm

sinaone

Updated 26-Mar-12 22:35pm

v2

Add a Solution

Comments

Amir Mahfoozi 27-Mar-12 6:28am

Please elaborate on this question because it is not clear what do you mean by saying "last inserted". Is the Date field formatted so that it doesn't show the time part or maybe it is of "Date" data type. So How should we find out what is the last inserted field ?

sinaone 27-Mar-12 10:43am

first thank you for your response
well we have a shift that it's work shift , so we have many shift in a day
and i want get last time that every IDType+IDPers are registered
for example IdType 1 + IDPers 1 is registerd in Date 2000/1/1 and Shift 2 in last time
so how can i get last time registerd every IDType+IDPers
thank you

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

angel94 · Answer 1 · 2012-03-27T00:02:00

Solution 1

Select Top 1 * From TableName Order By FieldName Desc

Posted 27-Mar-12 0:02am

angel94

Comments

sinaone 27-Mar-12 10:46am

i want get last time registerd every IDType+IDPers
but this select get back just a record
so this is wrong select
but however thank you for your response

[no name] 28-Mar-12 11:14am

Please try RANK methods or GROUP BY