All Posts

Ambiguous Coordinates Problem

LeetCode 816. We had some 2-dimensional coordinates, like “(1, 3)”...

30 Sep 2022

All Possible Full Binary Trees Problem

LeetCode 894. Given an integer n, return a list of...

30 Sep 2022

All Nodes Distance K In Binary Tree Problem

LeetCode 863. Given the root of a binary tree, the...

30 Sep 2022

Advantage Shuffle Problem

LeetCode 870. You are given two integer arrays nums1 and...

30 Sep 2022

Add To Array-Form Of Integer Problem

LeetCode 989. The array-form of an integer num is an...

30 Sep 2022

3Sum With Multiplicity Problem

LeetCode 923. Given an integer array arr, and an integer...

30 Sep 2022

How To Specify Unique Constraint For Multiple Columns In MySQL

How to make multiple columns unique (together) in an existing...

29 Sep 2022

How To Select One Row Per ID With Max Value On A Column

Suppose we have the following REIMBURSEMENT table, find the max...

29 Sep 2022

How To Get The Size Of A Table In MySQL

How to get the size of a table in MySQL...

29 Sep 2022

How To Get The Size Of A Database In MySQL

How to get the size of a database in MySQL...

29 Sep 2022

How To Concatenate Multiple Rows Into One Field In MySQL

How to concatenate multiple rows into one field in MySQL...

29 Sep 2022

How To Change The Data Type Of A Column In MySQL

Given a table EMPLOYEE, change the data type of the...

29 Sep 2022

Valid Triangle Number Problem

LeetCode 611. Given an integer array nums, return the number...

28 Sep 2022

Valid Tic-Tac-Toe State Problem

LeetCode 794. Given a Tic-Tac-Toe board as a string array...

28 Sep 2022

Valid Parenthesis String Problem

LeetCode 678. Given a string s containing only three types...

28 Sep 2022

Valid Palindrome II Problem

LeetCode 680. Given a string s, return true if the...

28 Sep 2022