/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

3 votes121 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote123 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
-1 vote123 views1 answer
What is in operator
SQL
1 vote117 views3 answers
Mariadb add foreign key
SQL
3 votes125 views1 answer
Laravel database Using Named Bindings
SQL
2 votes127 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
8 votes126 views1 answer
Oracle search source code
SQL
0 vote127 views1 answer
Find all tables where column name exists oracle
SQL
0 vote125 views1 answer
How to install sql in anaconda
SQL
0 vote131 views2 answers
Postgres having
SQL

Share