SQL Coding Exercise – Rank Scores
Submit your SQL to Leetcode online judge: https://oj.leetcode.com/problems/rank-scores/ Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. …
How to Fix Visual Studio Search in Files Not Displaying List of Files Error?
In Visual Studio, you can use short-cut Ctrl+Shift+F to find string in files (in solution, current project or current document), and sometimes you are unlucky to get this error: …
How To Remove All Blank Lines using Sed or VIM
The regular expressions simplify our lives. For example, if you want to remove all blank lines (empty), instead of writing any scripts or programs, you can simply use the …
How to Make First Letter in First Paragraph Big in WordPress (CSS) articles?
If you have noticed, now this page, the first letter is made big for all articles. To enable this, you can use the CSS tricks first-letter and first-child selector: …
Simple Version Number Updating in Batch File for Build Scripts
On windows, platform, the resource files (*.rc) can be used to define version and file information. The *.rc are compiled to *.res (binary) using e.g. brcc32.exe (the delphi resource …
How to Store File Information (Version) in Resource File for Delphi Projects
By Default, the Delphi IDE stores the file information (version) directly in compiled Resource File (*.res), which is binary so you can’t easily edit it using text editors. Sometimes, …