/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

7 votes279 views1 answer
Sql pagination oracle
SQL
0 vote279 views1 answer
Postgres row expiration
SQL
0 vote266 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote285 views1 answer
Oracle decode
SQL
0 vote297 views1 answer
Mysql average from two table
SQL
0 vote261 views1 answer
Mysql get last 2 month data
SQL
0 vote275 views1 answer
How to get parent and child record in single query using sql
SQL
-1 vote268 views1 answer
Capitole toulouse
SQL
36 votes291 views3 answers
Add column in mysq
SQL
0 vote270 views1 answer
Contraint default SQL
SQL

Share