sql week number starting monday

Solutions on MaxInterview for sql week number starting monday by the best coders in the world

showing results for - "sql week number starting monday"
Tomas
10 Mar 2019
1BEGIN TRANSACTION;
2
3/* Table Creation And Insertions */
4CREATE TABLE week(Number integer PRIMARY KEY, Name text);
5  INSERT INTO week VALUES(1, 'Monday')
6  INSERT INTO week VALUES(2, 'Tuesday')
7  INSERT INTO week VALUES(3, 'Wednesday')
8  INSERT INTO week VALUES(4, 'Thursday')
9  INSERT INTO week VALUES(5, 'Friday')
10  INSERT INTO week VALUES(6, 'Saturday')
11  INSERT INTO week VALUES(7, 'Sunday')
12COMMIT;
13
14/* Queries */
15SELECT name AS 'Day'
16FROM week
17WHERE name = 'Monday';
18
19/* Returns Monday' */