/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 vote108 views1 answer
<script>alert
SQL
0 vote105 views1 answer
Sql server python connection
SQL
6 votes121 views2 answers
If not exists insert sql
SQL
0 vote166 views1 answer
How to show current database in mysql
SQL
0 vote117 views2 answers
Sql server select first day of previous year
SQL
0 vote105 views1 answer
What is the essence of SQL?
SQL
0 vote133 views1 answer
Snowflake drop column
SQL
0 vote112 views1 answer
How to drop a trigger in postgresql
SQL
1 vote125 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote129 views1 answer
Mssql + bit + in python orm
SQL

Share