/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

1 vote178 views1 answer
Find logged in users mysql
SQL
0 vote297 views1 answer
How to update random rows in sql
SQL
0 vote187 views2 answers
How to update the multiple rows in sql
SQL
1 vote227 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote184 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
1 vote236 views1 answer
Mysql tables max count
SQL
15 votes181 views4 answers
Mysql where value is null
SQL
1 vote206 views1 answer
Postgres see sequence current state
SQL
0 vote188 views1 answer
Drop all triggers oracle
SQL
0 vote223 views1 answer
Compress sql file database ubuntu
SQL

Share