/SQL/Last working day in week date function in sql

Last working day in week date function in sql

Sql last week

select min(date), max(date)
from calendar
where week = datepart(week, getdate() - 7)
and year = datepart(year, getdate() - 7)

1

Source: stackoverflow.com

Date sql get the last week count

select * from dt_table where  `date` >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)

0

Source: plus2net.com

Similar codes

-3 votes301 views8 answers
Sql to c# linq converter online
SQL
8 votes218 views1 answer
How to remove tables from postgresql
SQL
1 vote235 views1 answer
Pl sql ptint
SQL
0 vote239 views1 answer
Codeigniter 3 get best-selling products
SQL
2 votes222 views1 answer
Oracle index size
SQL
1 vote257 views1 answer
Primary key with prefix sql
SQL
0 vote228 views1 answer
SQL Server Altering Column to be Unique
SQL
-1 vote240 views2 answers
Postgres autoincrement primary key
SQL
3 votes231 views4 answers
Show databases in sql server
SQL
0 vote220 views4 answers
Database stuck at restoring state
SQL

Share