How to fetch most recent record in sql

01:05top one star from human resource

01:08employee and order by

01:12file date in deceiving you will get the

01:15latest higher date

01:17for the table home and resources imply

01:21i have another method also to get the

01:24latest record from the table

01:28so i have table human resources

01:30department i want a latest department

01:34id from the table human resources

01:37department

01:52department id

01:56department id from

01:59human resources department type

02:03table

02:04so you will get the latest department id

02:10you can see you receive the latest

02:12department id but you need all the

02:14column for the table right so in that

02:18scenario you have to use where

02:21department

02:23id equal to you have

02:27open bracket and close the bracket here

02:30you will receive the latest department

02:33id including all the columns

02:36now i have another

02:38method also to get the latest department

02:43so i

02:44so the table human resources department

02:47order by department id decision i am

02:51going to use offset

02:56offset zero rows h first

03:00one row only so this will take a latest

03:04record and latest

03:07record from the table homie resources

03:10department you can see this is the

03:13latest record which got inserted and

03:16the table containing the latest record

03:19is a department id 22 including this

03:22column so this is the three way you can

03:25receive the

03:27latest record from the table this is the

03:30first

03:31this is the second and this is the

03:35third method to get the and face the

03:39latest

03:40record from the table thanks for

03:43watching sql guide please share and

03:45subscribe my channel