Need to fetch latest record always and ignore if there is no latest data Basically i want to send mail whenever there is a new record in this table throughout the day with list of all records got created.

I have a table with one date column. i have to always fetch the latest data based on that column and it should not give nay result if there is no latest record after the last one.

For ex:- latest record pulled at 9 AM and after that there is no update then it should not pull the same data again.
I would look at creating a trigger on the table, and having the trigger set to email the inserted rows as appropriate. 

There is no point me explaining how exactly, as Aaron Bertrand gave a super answer to this premise here: https://stackoverflow.com/questions/10755469/send-e-mail-from-a-trigger

I have implemented this sucesfully to send email alerts when certain values change or rows are deleted. Works perfectly.