Top 5 rows

[Scadhasini]

Hi,
How to get top 5 newly entered rows in a table. i am trying with "select top 5 * from Test" but its giving old entries.if i want new entries how?

[vinaykeshav]

if u have an date col under this table then..
select top 5 * from test order by desc of date col

[Scadhasini]

if u have an date col under this table then..
select top 5 * from test order by desc of date col

Hi Vinay,
i have date col, but i am joining with another table. i am using where clause for date its not giving top 5 rows

[almaz]

Hi Vinay,
i have date col, but i am joining with another table. i am using where clause for date its not giving top 5 rows

Once again: There is no term "order of records in database".
If you want to get records with some order, you must provide an ORDER BY clause. Without ORDER BY clause select returns unordered list of records, that occasionally may be returned in the order you want. If you don't have a field that you can use to determine latest records - you wouldn't be able to get the last records in consistent manner. If you do have such a field - use ORDER BY [this field] DESC/ASC and select top records.
If you want to get more information about your particular case - provide us with DDL (data definition language: scripts for table creations) scripts and queries you're trying to run

[willakawill]

Hi Vinay,
i have date col, but i am joining with another table. i am using where clause for date its not giving top 5 rows

Hi
is there an auto number id field for this table?

[Scadhasini]

Hi
is there an auto number id field for this table?

yes it is there "itemid". this is my query

Select ModuleId,
ItemId,
Content,
CreatedByUser,
CreatedDate
from Test with (nolock)
Left Outer Join Users On Test.CreatedByU ser = Users.UserId
Where CreatedDate in (Select Top 5 CreatedDate from Test Order By CreatedDate Desc) And ModuleId = @ModuleId

with this @ModuleId i have so many rows in the table.but its returning always 3rows only .

[cyberdwarf]

Try adding:-

Select top 5.....

at the top of your query and....

order by ItemId Desc

at the bottom.

HTH

Steve

[Scadhasini]

Try adding:-

Select top 5.....

at the top of your query and....

order by ItemId Desc

at the bottom.

HTH

Steve

thank u i solved .....