How to find specify row value in SQL

Question

I have a table it's name is table1  in it 3 column is specified  column name is id name date if in name column three are three same name like abc abc abc add id is a primary key how to get second last name and date in this table. table may be contain lot of records.

Adil Ansari · Answer

Use Below SQL Please note: This way you will get the second last row (name date). Incase if you need 3rd last you need to increase the ' red ' number to 2 and so on...... Hope I answer your question SELECT TOP 1 * FROM [Table1] WHERE ID NOT IN (SELECT TOP 1 ID FROM [Table1] ORDER BY ID DESC) ORDER BY ID DESC