Publog Developer Blog of Shivishbrahma

Recent Posts

Snowflake SQL Cheatsheet

snowflake sql cheatsheet
2 minutes 07 August 2025
SQL Essentials Joins Join Type Description Syntax INNER Returns rows that match on both sides of the join SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column LEFT Returns all rows from the left table, and the matched rows from the right table SELECT * FROM table1 LEFT...

Python Core Cheatsheet

python cheatsheet
7 minutes 25 July 2025
Date and Time Date Directives Format Meaning Example %Y Year (4 digits) 2025 %y Year (2 digits) 25 %m Month (01-12) 07 %B Full month name July %b Abbreviated month name Jul %d Day of the month (01–31) 17 %j Day of year (001–366) 198 %A Full weekday name Thursday...

Top SQL Interview Questions

sql interview mysql postgresql
2 minutes 27 June 2025
Write an SQL query to fetch the second-highest salary from an employees table. SELECT MAX(salary) AS SecondHighestSalary FROM employees WHERE salary < (SELECT MAX(salary) FROM employees); SELECT salary AS SecondHighestSalary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1; SELECT salary AS SecondHighestSalary FROM ( SELECT salary, row_number() OVER...

Nano Shortcuts - Beginner Friendly Editor

nano shortcut editor text
3 minutes 06 January 2025
When it comes to text editing in the terminal, Nano stands out. It is user-friendly and simple. Nano’s straightforward interface makes it an excellent choice for anyone from novice to expert. In this blog post, we will explore essential Nano shortcuts. These will help you navigate and use this powerful...

Custom WAMMP Setup in Windows (mod_wsgi support)

windows apache php
2 minutes 30 April 2023
Are you tired of using pre-packaged WAMPP solutions that limit your control and flexibility? Do you need to run Python web applications on Windows using the Apache web server? Look no further! This guide will walk you through the process of setting up a custom WAMPP environment on Windows, complete...