/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 vote196 views1 answer
Test the postgresql db connection
SQL
0 vote205 views1 answer
Sql server for loop
SQL
0 vote210 views1 answer
Import excel to sql
SQL
0 vote192 views1 answer
Mysql workbench format date
SQL
7 votes231 views1 answer
Mysql unsafe update
SQL
4 votes200 views2 answers
Oracle default date format
SQL
1 vote192 views1 answer
Influxdb export to csv
SQL
0 vote233 views1 answer
Postgresql on conflict pair
SQL
0 vote192 views1 answer
Select from another database
SQL
1 vote327 views2 answers
Postgres select from last 3 months
SQL

Share