/SQL/Last working day in week date function in sql

Last working day in week date function in sql

Sql last week

select min(date), max(date)
from calendar
where week = datepart(week, getdate() - 7)
and year = datepart(year, getdate() - 7)

1

Source: stackoverflow.com

Date sql get the last week count

select * from dt_table where  `date` >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)

0

Source: plus2net.com

Similar codes

0 vote344 views1 answer
Sql reverse order of results
SQL
0 vote301 views1 answer
Create dabase postgresql
SQL
26 votes338 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote352 views1 answer
Sql last 3 rows
SQL
0 vote330 views1 answer
Plsql check for string in numeric
SQL
0 vote372 views1 answer
Check if mysql db is used
SQL
6 votes337 views5 answers
Mysql get last insert id
SQL
0 vote338 views1 answer
Xampp increame mysql speed
SQL
2 votes348 views1 answer
Find all triggers in database
SQL
1 vote323 views2 answers
Sql groub by count
SQL

Share