/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

0 vote310 views1 answer
Plsql trigger insert update
SQL
0 vote384 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
2 votes353 views1 answer
How to delete view in sql
SQL
-2 votes354 views1 answer
No module named '_sqlite3
SQL
2 votes355 views1 answer
Mysql clear screen
SQL
0 vote370 views2 answers
Mysql calcular idade
SQL
0 vote340 views1 answer
Foreign key multiple columns
SQL
57 votes546 views6 answers
Sql alter table
SQL
0 vote375 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote392 views1 answer
Mysql sum per week
SQL

Share