ERROR

[kibromg]

Hi all, Select distinct(Mobile), ROW_NUMBER() OVER(PARTITION BY mobile ORDER BY dateofcall DESC ) AS 'RowNumber' from Call having RowNumber=1 Error Invalid coulmn RowNumber Can any one advice please? Thank you

[Lost User]

The columname-alias "RowNumber" can only be used in a ORDER BY clause. Try this one;

SELECT TOP 1
distinct(Mobile), ROW_NUMBER() OVER(PARTITION BY mobile ORDER BY dateofcall DESC ) AS 'RowNumber' from Call

I are troll :)

[kibromg]

top 1 returns one record.what i want is to select only those that has a first entry to my database.RowNumber=1

[Lost User]

You can change the sorting by changing the ORDER BY clause, so that the first row is the first entry :)

I are troll :)