/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 vote398 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote304 views2 answers
Install phoenix
SQL
0 vote402 views1 answer
How to subquey to do not load in live database in
SQL
0 vote334 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote317 views1 answer
Oracle list subpartitions
SQL
0 vote372 views1 answer
Site:av.ru "files"
SQL
1 vote322 views1 answer
Load mysql dumb
SQL
3 votes298 views1 answer
Sql select all
SQL
0 vote320 views1 answer
Sql tablo hangi sp de
SQL
0 vote328 views1 answer
Changing name of column and datatype in sql
SQL

Share