SQL help

[njimack]

I'm still a novice when it comes to writing SQL's, and I'm really struggling with a particular project.


We use an Excel add-in that contains an SQL editor to query our core database. This means that if a query returns more than 65,000 rows, the data is incomplete.

In order to only return the relevant data, I want to restrict the records I query in a particular table to just the 2 most recent records.

If anyone could point me in the right direction or suggest a suitable website, I'd be extremely grateful.

Thanks

 

[SydneyGeek]

To get the last 2 records, sort Descending on the table's ID and run a Top records query. As an example, this will select the Top 2 records from a sample table --

SELECT TOP 2 tblDateTest.DateID, tblDateTest.TestDate
FROM tblDateTest
ORDER BY tblDateTest.DateID DESC;

Denis

 

[njimack]

Denis,

Thanks, I'll give that a go.