Query for last 85 records in database

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mathew J Kulangara SSCommitted Points: 1610 More actions · Answer 1

Your ddl would be helpful...

but..something like....

select top 85 [identity_field],*

from table t

order by [identity_field] desc

HTH

SQL2DAY SSC Veteran Points: 233 More actions · Answer 2

Thank You--

I tried this and it worked great. What is ddl?

SQL2DAY

Mathew J Kulangara SSCommitted Points: 1610 More actions · Answer 3

ddl = data definition language

basically your table structures etc...

Glad it worked 🙂