Viewing 9 posts - 1 through 9 (of 9 total)
Great man... that's what I needed.
And regarding your assumption: ID is Primary key so you can see unique.
April 6, 2006 at 6:38 am
That's great and thanks for your work.
I have one question....
Can I manage whole process by one query? if it is so then how can I write such query by managing...
April 6, 2006 at 3:55 am
Let me specify in more details....
Table Name: tblName
Column Name: id,Name
Some rows from this table:
id Name
----------------
1 Sanket
2...
April 4, 2006 at 11:18 pm
Yes, thats true, but actually when I posted first time, bymistaken I pushed it submitted twice and luckily I got response from both threads and that is why whole senario is...
April 3, 2006 at 7:13 am
Yes it worked for me....
Thanks
Sanket
April 3, 2006 at 7:01 am
Thanks Amit...
That worked for me...
Actually only single query is needed here.
select * from (select top 5 * from authors order by au_id desc) a
order by 1
what do you say?
Thanks
Sanket
April 3, 2006 at 6:57 am
Hi Sushila,
You might misunderstood my query....
I wanted last five records that means if i have 50 records then i want records like 45,46,47,48,49 and 50th.
Can you please check it out...
April 3, 2006 at 6:50 am
Viewing 9 posts - 1 through 9 (of 9 total)