/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 vote142 views1 answer
Sql case when exists in another table
SQL
0 vote147 views1 answer
Select row with latest date mysql
SQL
20 votes143 views5 answers
Mysql reset auto increment to 1
SQL
6 votes137 views6 answers
Count mysql
SQL
14 votes155 views3 answers
How to add default constraint in mysql
SQL
-1 vote102 views1 answer
Mysql how to set update or create
SQL
3 votes134 views1 answer
What is having clause
SQL
3 votes142 views1 answer
Only join in sql
SQL
16 votes145 views6 answers
Install sqlite3 python
SQL
1 vote141 views1 answer
Mysql get domain from url
SQL

Share