SQL Server SELECT LAST N Rows

sql sql-server performance sql-server-2008
Diego picture Diego · Nov 16, 2010 · Viewed 683.4k times · Source

This is a known question but the best solution I've found is something like:

SELECT TOP N *
FROM MyTable
ORDER BY Id DESC

I've a table with lots of rows. It is not a posibility to use that query because it takes lot of time. So how can I do to select last N rows without using ORDER BY?

EDIT

Sorry duplicated question of this one

Answer

Niru Mukund Shah picture Niru Mukund Shah · Mar 15, 2013

You can make SQL server to select last N rows using this SQL:

select * from tbl_name order by id desc limit N;

Related questions

Multiple INSERT statements vs. single INSERT with multiple VALUES

I'm running a performance comparison between using 1000 INSERT statements: INSERT INTO T_TESTS (TestId, FirstName, LastName, Age) VALUES ('6f3f7257-a3d8-4a78-b2e1-c9b767cfe1c1', 'First 0', 'Last 0', 0) INSERT INTO T_TESTS (…

Read More
SQL Server Web vs Standard edition

I have found out that there's two versions of SQL Server types that are very different in terms of pricing... The Web version from my host provider costs about 13$ per 2 core packs, whereas the Standard edition is right around 200$. From …

Read More
Why is a UDF so much slower than a subquery?

I have a case where I need to translate (lookup) several values from the same table. The first way I wrote it, was using subqueries: SELECT (SELECT id FROM user WHERE user_pk = created_by) AS creator, (SELECT id FROM …

Read More