/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 vote179 views1 answer
Code to move ietms from one table to another myswl
SQL
0 vote177 views1 answer
User defined variables in sql
SQL
0 vote177 views1 answer
Mysql add root password
SQL
3 votes160 views3 answers
Print in pl sql
SQL
0 vote193 views1 answer
Like date sql server not working
SQL
0 vote191 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
2 votes184 views2 answers
Sql percentage
SQL
8 votes188 views10 answers
Sql
SQL
1 vote390 views1 answer
How to make a select in sql
SQL
1 vote185 views1 answer
Table valued functions in sql
SQL

Share