Tag Archives: SQL

Database and SQL – 2

The post focuses on providing a thought to make comparison for values on the same column in SQL query. The idea came up with the Leetcode exercise “Rising Temperature” and “Consecutive Numbers”. As a long time Excel user, I usually make comparison for values in one column by use formula. The below is an exampleContinue reading “Database and SQL – 2”

Database and SQL – 1

SQL is short for Structured Query Language. From its words you can tell, it is a tool to query something from somewhere. It is a declarative language but not procedural language. It means that you just use it to tell what you want to get from somewhere rather than tell how to your results areContinue reading “Database and SQL – 1”