How to get second last record

SELECT TOP 1 * From
(select Top 2 * from Students ORDER BY StudentId DESC) x                    
ORDER BY StudentId;

OR

select * from Students where StudentId=(select max(StudentId)-1 from Students);


OR

SELECT StudentId, StudentName
FROM Students  
ORDER BY StudentId desc 
LIMIT 1, 1;

Here is the query to get the second last record in MySQL

SELECT *FROM
(SELECT *FROM yourTableName ORDER BY yourIdColumnName DESC LIMIT 2)
anyAliasName
ORDER BY yourIdColumnName LIMIT 1;

SELECT *  From (select * from student ORDER BY ID DESC LIMIT 2) AS studentlastsecondrecord ORDER BY ID LIMIT 1;

To get the second last record details of a student from the student details table, you can use SQL queries with appropriate filtering and ordering. Here's an example assuming you have a "Students" table with columns "StudentID" and "StudentName":

SELECT TOP 1 *
FROM Students
WHERE StudentID < (SELECT MAX(StudentID) FROM Students)
ORDER BY StudentID DESC;

SELECT TOP 1 StudentID, StudentName
FROM Students
ORDER BY StudentID DESC
OFFSET 1 ROW
FETCH NEXT 1 ROW ONLY;
 

Hello Ramco,

wa can do below one in verious way but if you are using sql server version 2012 or above then best way to do this one as below,

SELECT CustomerID
FROM custiners
ORDER BY CustomerID DESC
OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;

Here :

OFFSET : The number of rows to skip before starting to return rows from the query

FETCH NEXT :  the number of rows to return after the OFFSET clause has been processed.

• We need last 2nd mean need to do order by desc by your primery key id in our case here it is customerId
• we want second record so we need to skip one record means OFFSET = 1
• we want only one record so we need FETCH NEXT = 1

To retrieve the second last record from a student details table using SQL, you can make use of the ORDER BY and LIMIT clauses. Here's an example query assuming you have a table named student_details with a primary key column named id:

SELECT *
FROM student_details
ORDER BY id DESC
LIMIT 1 OFFSET 1;

Explanation:

• The ORDER BY clause is used to sort the records in descending order based on the id column. Assuming higher id values are more recent, this will arrange the records from the most recent to the oldest.
• The LIMIT clause is used to limit the number of records returned. In this case, we set it to 1 to retrieve only one record.
• The OFFSET clause is used to skip a certain number of records. By setting it to 1, we skip the first record (the most recent) and retrieve the second last record.

Make sure to replace student_details and id with the actual table and column names in your database.

SELECT top 1 * FROM Student WHERE id < (SELECT MAX(id) FROM Student)

order by Id desc