/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 vote179 views1 answer
Mysql bash execute sql file
SQL
0 vote178 views1 answer
Sql server datetime to string
SQL
0 vote180 views1 answer
How to select only a certain date sql
SQL
0 vote181 views1 answer
T-sql conditional order by multiple columns
SQL
0 vote180 views1 answer
Mysql user set plugin
SQL
0 vote189 views1 answer
Search from comma separated values in sql server
SQL
0 vote171 views1 answer
Partitioning in oracle-base
SQL
1 vote148 views2 answers
Delete auto increment mysql
SQL
9 votes201 views6 answers
Oracle substring
SQL
8 votes172 views1 answer
Unique vs primary key
SQL

Share