How to get second last record

Question

Hi I have student details table. I want to get the second last record details of student Thanks

Amit Mohanty · Answer

SELECT TOP 1 * FROM ( SELECT TOP 2 * FROM StudentDetailsTable ORDER BY StudentID DESC ) AS SubQuery ORDER BY StudentID ASC; //OR SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY StudentID DESC) AS RowNum FROM StudentDetails ) AS SubQuery WHERE RowNum = 2;

Brahma Prakash Shukla · Answer

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

Deepak Rawat · Answer

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

Jignesh Kumar · Answer

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

Prasad Raveendran · Answer

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.

Mukesh Sagar · Answer

SELECT top 1 * FROM Student WHERE id order by Id desc

Vishal Yelve · Answer

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;

Kisorjan Jakathiswaran · Answer

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;

How to get second last record

Answers (8)