/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 votes368 views1 answer
Oracle list user grants
SQL
0 vote339 views1 answer
Version and edition of SQL Server Database Engine
SQL
1 vote379 views1 answer
Mysql select and count left join
SQL
1 vote350 views1 answer
Last 6 months postgresql
SQL
0 vote343 views2 answers
Install phoenix
SQL
0 vote356 views1 answer
Group by sql not ordering issues
SQL
26 votes368 views2 answers
Mysql workbench download
SQL
0 vote378 views1 answer
Postgresql port 5432 not open
SQL
0 vote344 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote418 views1 answer
Eliminate zero from integer mysql
SQL

Share