last ten records

[Pankaj Garg]

Like , i can select top 10 records , how can i select last 10 records . I used the following query , but did not work. select top 10 columnname from tablename order by columnname desc

If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!

[MHASSANF]

i think this is because of your "order"

[Christian Graus]

This is a SQL question, try the SQL forum. But, changing from ASC to DESC, will work.

Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

[Guffa]

Pankaj Garg wrote:

but did not work

You have to be a lot more specific. That something "did not work" is not a useful description. What happened? What did you expect it to do, and how did what it do differ from what you expected? Did you get any error message?

Pankaj Garg wrote:

select top 10 columnname from tablename order by columnname desc

You have to be a lot more specific. That is exactly the example that you would get as answer to your question. What does the actual code that you used look like?

Despite everything, the person most likely to be fooling you next is yourself.