/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 vote138 views2 answers
Which MySQL statement is used to delete data from a database
SQL
40 votes194 views6 answers
Update table mysql
SQL
0 vote151 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
4 votes120 views1 answer
Oracle table statistics last analyzed
SQL
0 vote126 views1 answer
Mysql begin statement
SQL
0 vote145 views1 answer
For row in sql database python loop
SQL
0 vote141 views1 answer
Query for backup a database at another location in file system
SQL
0 vote135 views1 answer
Joomla execute raw sql
SQL
0 vote133 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote136 views1 answer
Mysql update privileges
SQL

Share