/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 vote162 views1 answer
Get last updated row sql server
SQL
1 vote163 views1 answer
Nullif postgresql
SQL
0 vote230 views1 answer
Mssql unique key accept nulls
SQL
0 vote144 views1 answer
How to use sqlcommand
SQL
2 votes144 views2 answers
How to view created temporary tables in mysql
SQL
0 vote658 views1 answer
T sql less than date
SQL
0 vote151 views1 answer
Flush user resource mysql
SQL
1 vote144 views1 answer
Sql eliminare un record
SQL
-1 vote155 views1 answer
How to reset autoincrement in sqlite java
SQL
0 vote140 views3 answers
How to verify sequence result in oracle SQL
SQL

Share