VB.net: SQL Opposite of SELECT TOP
Hi
What is the opposite of SELECT TOP in SQL
I need to only select eg the bottom/last 50 records added to my table
What is the opposite of SELECT TOP in SQL
I need to only select eg the bottom/last 50 records added to my table
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
possibly by using a VIEW instead of the table itself, which returns the data as needed...
The only way I can see to do this would be dumping the SQL into a temp table, then delete COUNT(*)-50.
ASKER
Hi. I tested the Order By method and I don't think that this works
If have Select Top 10 * From Table1 then this selects the first 10 records
If you then Select * From(Select Top 10 * From Table1) Order By ID
this just selects the same top 10 but just puts them in reverse order.
Or am I confused?
If have Select Top 10 * From Table1 then this selects the first 10 records
If you then Select * From(Select Top 10 * From Table1) Order By ID
this just selects the same top 10 but just puts them in reverse order.
Or am I confused?
I'm not sure what you mean exactly when you say '...automated system where any SQL statement can be used...'
Are users sending their own SQL to run? Do you have a way of determining via sorting what the last records added are, e.g. time stamp or increasing index field? If you don't have such a way of ordering, then 'SELECT ' wouldn't guarantee to return records in any particular sequence.
you could do sometking like
Are users sending their own SQL to run? Do you have a way of determining via sorting what the last records added are, e.g. time stamp or increasing index field? If you don't have such a way of ordering, then 'SELECT ' wouldn't guarantee to return records in any particular sequence.
you could do sometking like
WITH BOTTOM50 as (SELECT TOP 50 * FROM YourTable ORDER BY TimeStamp DESC)
SELECT * FROM BOTTOM50 ORDER BY AnyField --any SQL you like on the second row
What you wanted to do was:
Select * From(Select Top 10 * From Table1 Order by ID DESC) Order By ID
Select * From(Select Top 10 * From Table1 Order by ID DESC) Order By ID
ASKER
Thanks. That does actually work. Sorry about the confusion
ASKER
This is an automated system where any SQL statement can be used so the Order By part
may not be known. Is there a way to make provision for this?