/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

11 votes274 views1 answer
How to get ddl for materialized view
SQL
1 vote319 views1 answer
Homebrew install mysql
SQL
0 vote276 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote278 views1 answer
Oracle job schedules
SQL
11 votes282 views2 answers
Having in sql
SQL
36 votes296 views6 answers
Rename table sql
SQL
0 vote304 views1 answer
Ansi sql count duplicate rows
SQL
0 vote299 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote303 views1 answer
SQL division of an integer by another integer get float CAST
SQL
1 vote282 views1 answer
Full sql mode
SQL

Share