Skip to content

tzyychin/LeetCode

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits
 
 
 
 
 
 

Repository files navigation

Change Notes

  • 6/7 moved python files to Python folder

Recursive Notes

"To iterate is human, to recurse, divine." Speaking of Programming, recursion is possibly one of the most challenging parts to be implemented especially when it comes with some data structures such as linked list.

… To be continued

SQL Notes

UPDATE

UPDATE
SET column1 = value1, column2 = value2
WHERE condition
CASE [option: expression]
    WHEN condition_1 THEN value_1
    WHEN condition_N-1 THEN value_N-1
    ELSE value_N
END

JOIN

self join
SELECT column1, column2, …
FROM table1 T1, table1 T2
WHERE condition

DELET

DELETE FROM table_name
WHERE condition;