/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 vote138 views1 answer
Pl sql turn off variable substitution
SQL
0 vote157 views1 answer
Sqlalchemy query join many to many
SQL
2 votes145 views1 answer
Mysql time ago difference
SQL
1 vote234 views1 answer
Postgres set column based on another column
SQL
0 vote181 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
2 votes135 views1 answer
Possgress drop if exists table
SQL
1 vote141 views1 answer
Isnull sql server
SQL
0 vote129 views1 answer
How to define a save method in ruby for sql databases
SQL
0 vote152 views1 answer
Postgresql print variable
SQL
1 vote177 views1 answer
Ora-01950 no privileges on tablespace
SQL

Share