Sql

Search

from weeknumber to date

"select WEEK(date) as week,"  
"sum(marks) as marks, sum(marks2) as marks2," 
"sum(marks3) as marks3,sum(marks4) as marks4," 
"sum(marks5) as marks5, sum(marks6) as marks6, " 
"DATE_ADD(date, INTERVAL(1-DAYOFWEEK(date)) DAY) as start_date," 
"DATE_ADD(date, INTERVAL(7-DAYOFWEEK(date)) DAY) as end_date " 
"from test_ashu_marks where subject not like '%math%' and " 
"date >= DATE_ADD(CURDATE(), INTERVAL - 31 DAY) " 
"group by week,start_date,end_date order by week desc"

Comment

PREVIOUS	NEXT

Code Example
Sql :: best practive to pass multiple table to stored procedure in sql server
Sql :: There are multiple records in a table and some are duplicates. Which command will fetch only one copy of the duplicate records? Pick ONE option SELECT DISTINCT SELECT UNIQUE SELECT DIFFERENT All of the above
Sql :: create mysql pool connection python flask
Sql :: How to Group by and concatenate arrays with all columns in PostgreSQL
Sql :: SQL Backup Only New Changes in SQL
Sql :: python mysqlclient library not found for -lssl
Sql :: ORA-32794: cannot drop a system-generated sequence
Sql :: Rows, INSERT INTO, Returning with alias
Sql :: sql datediff db2
Sql :: sql queries for interview
Sql :: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it (SQL: select * from `featured_categories` limit 1)
Sql :: in operator in sql
Sql :: modificar tipo de dato sql server
Sql :: sql trim
Sql :: cast float mysql
Sql :: how to use db.execute
Sql :: mysql storage engines
Sql :: sql query by rahuldev
Sql :: how to retrive image from sql to picturebox usinf image location
Csharp :: unity hide mouse
Csharp :: unity how to change rotation
Csharp :: unity how to get y value
Csharp :: bitmasking in c#
Csharp :: c# for each textbox lines
Csharp :: c# player movement
Csharp :: c# datetime dd/mm/yyy hh:mm:ss
Csharp :: unity run void from another script
Csharp :: vscode c# how to change to externial terminal
Csharp :: exit application wpf
Csharp :: random from list c#

Search

SQL

from weeknumber to date

ADD CONTENT