Off Belay forum


View latest messages in My Forums
This topic has been archived, and won't accept reply postings.

Topic - SQL Puzzler

mostly harmless - on 30 Nov 2012
A slight variation here, in that the code works but I don't understand why. Can anyone tell me what the "any_string_here" does after the brackets where the table is partitioned. It works with any characters but I don't understand why.

Thanks in adavance

Dave

-------------------------------------------------------

DECLARE @TABLE TABLE (A INT, B INT,C VARCHAR(6))

INSERT INTO @TABLE VALUES
(1,123,'abc'),(1,122,'abc'),
(1,121,'abc'),(2,23,'z'),
(2,23,'efg'),(2,23,'ahij')

SELECT * FROM @TABLE

SELECT
A,B,C,ROWNUM FROM(
SELECT A,B,C,ROW_NUMBER() OVER(PARTITION BY A ORDER BY B DESC) ROWNUM
FROM @TABLE
) any_string_here
WHERE ROWNUM = 1
... not showing 5 replies to this topic ...
Register as a New User or login to gain full access to the forums. Registration is quick and completely free.
If you are definitely logged on, press Ctrl+F5 keys to reload this page [read more]

Unregistered users can only read messages in the most recent topics.
ads.ukclimbing.com

This topic has been archived, and won't accept reply postings.

My Forums