Skip to content
Tags

SQL Get Last Entry For Each Type In Data Log Using RANK()

May 30, 2012
WITH	a AS ( SELECT	*, RANK() OVER ( PARTITION BY System ORDER BY LogTime DESC ) r
			   FROM		tblLog)
	SELECT	*
	FROM	a
	WHERE	r = 1
Advertisements

From → SQL

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: