fetch the last time records from current date

multi 4u

9y1.1k

hii friends ...Good Afternoon..

I have a table name as "Recharge" and it has a column recharge_date and Current_bal

now i want to fetch last data or value from column current_bal of last day.

like-

I want the last data or value of yesterday from column current_bal.

How can i do that...

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
try this
select top 1 Current_bal from Recharge order by recharge_date desc
Ramesh Barik9y ago
declare @dt datetime;
WITH Res AS (SELECT
ROW_NUMBER() OVER (
PARTITION BY R.recharge_date ORDER BY R.Current_bal ASC
) AS Row
,recharge_date
,Current_bal
FROM Recharge R WHERE convert(date,recharge_date)= CONVERT(date,@dt-1))
SELECT
recharge_date
,Current_bal
FROM Res
WHERE row = 1;

Check this quey it may help you.
Amit Gupta9y ago
Fetch the records using order by clause
select Top 1 * from Recharge
order by recharge_date desc

-- or if you have identity column,  will get much efficient result

select Top 1 * from Recharge
order by id desc
Amit Gupta9y ago
Fetch the records using order by clause
select Top 1 * from Recharge
order by recharge_date desc

-- or if you have identity column,  will get much efficient result

select Top 1 * from Recharge
order by id desc
multi 4u9y ago
Thanx But not up to the mark..
Ehsan Sajjad9y ago
There are sql server built-in provided functions which can be used to get last day date and then check in where clause to fetch the records of yesterday, an example would be:
SELECT Current_bal
From Recharge
Where recharge_date =  dateadd(day,datediff(day,1,GETDATE()),0)