Query to get last position by User

I have the following table

CREATE TABLE [dbo].[PRC_PosizioniWalkers]
(
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [idWalker] [int] NOT NULL,
    [username] [nvarchar](200) NOT NULL,
    [data] [datetime] NULL,
    [Latitudine] [nvarchar](50) NOT NULL,
    [Longitudine] [nvarchar](50) NOT NULL,

    CONSTRAINT [PK_PRC_PosizioniWalkers] 
        PRIMARY KEY CLUSTERED ([ID] ASC)
                WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
                      IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, 
                      ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Now I need to write a query to get for every idWalker the last position. So to speak the result of the query should be:

What query do I need to write to get this result?

You need to sign in to view this answers

Related Post