Home 2018 July SQL Puzzle: Get the last three Records of a table

SQL Puzzle: Get the last three Records of a table

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Check the below input data and expected output to get the last three records of a table.

Input Data:

Expected Output:

Create a sample table:

Solution:

Please try the different solution for this puzzle and share it via comment...

Anvesh Patel
SQL Server: Script to check the file exists or not (Using xp_fileexist )SQL Server: Basic performance test between SELECT INTO and INSERT INTO SELECT
Comments: 11
  1. Sai Reddy
    July 17, 2018 at 5:09 am

    select * from tbl_TestTable
    ORDER BY id ASC
    OFFSET 6 ROWS
    FETCH NEXT 3 ROWS ONLY

    ReplyCancel
  2. Shamanth
    July 17, 2018 at 7:42 am

    Select * From (Select top 3 ID,Name from tbl_TestTable TT order by TT.Id desc) T
    Order By T.ID Asc

    ReplyCancel
  3. lymo
    July 25, 2018 at 4:49 am

    select * from tbl_testtable offset (select count(1)-3 from tbl_testtable) limit 3;

    ReplyCancel
    • Aamir Ali
      August 20, 2018 at 11:31 am

      SELECT * FROM public.employees
      ORDER BY employee_number desc limit 3

      ReplyCancel
  4. Sunil Jadhav
    September 25, 2018 at 12:02 pm

    SELECT * FROM tbl_TestTable ORDER BY ID ASC LIMIT 3
    OFFSET (SELECT COUNT(*) FROM tbl_TestTable) – 3;

    ReplyCancel
  5. sudesh kumar
    September 28, 2018 at 1:19 pm

    select * from (
    select top 3 * from tbl_TestTable order by 1 desc
    ) s order by 1

    ReplyCancel
  6. ganag
    October 4, 2018 at 12:46 pm

    ;with cte as (
    select top 3 * from tbl_TestTable order by 1 desc
    )
    select * from cte order by 1 asc

    ReplyCancel
  7. Praful Raut
    October 10, 2018 at 5:42 am

    SELECT ID, NAME FROM #TBL_TESTTABLE WHERE ID >=7

    ReplyCancel
  8. MB
    October 11, 2018 at 1:44 pm

    Answers relying on ID being correlated to the position of a record are probably bad practice given that there are easy general solutions available.

    ReplyCancel
  9. HIC
    April 9, 2019 at 6:28 pm

    select *
    from (
    select * from tbl_TestTop order by id desc)
    where rownum <= 3
    order by id;

    ReplyCancel

Leave a Reply

CAPTCHA

*

Anvesh Patel
Anvesh Patel

Database Engineer

July 16, 2018 11 Comments SQL Puzzle, , , , , , , , , , , , ,