/SQL/Sql last week

Sql last week

Sql select data from last week

select id from tbname

where date between date_sub(now(),INTERVAL 1 WEEK) and now();

2

Sql select data from last week

select id from tbname

where date between date_sub(now(),INTERVAL 1 WEEK) and now();

1

Source: stackoverflow.com

Sql last week

select min(date), max(date)
from calendar
where week = datepart(week, getdate() - 7)
and year = datepart(year, getdate() - 7)

0

Source: stackoverflow.com

Similar codes

0 vote285 views1 answer
MySQL update with subquery
SQL
0 vote267 views1 answer
Mysql database hyphen
SQL
10 votes277 views2 answers
SQL rounding numbers
SQL
2 votes268 views1 answer
Mysql sysdate - 1 day
SQL
0 vote292 views1 answer
Sql query wordpress export post
SQL
1 vote281 views2 answers
Foreign key set 0
SQL
1 vote283 views1 answer
Create new index takes long time postgresql
SQL
1 vote275 views1 answer
Right outer vs left outer join
SQL
1 vote283 views1 answer
Update foreign key value in mysql
SQL
4 votes406 views6 answers
Laravel jwt
SQL

Share