SQLrevisited

Blog to learn about SQL, database, Oracle, SQL Server, MySQL, PostgreSQL concepts and much more.

Saturday, October 11, 2025

The Database Administrator RoadMap

›
As the digital realm continues to advance at a rapid pace, the role of a Database Administrator (DBA) becomes increasingly vital in ensuring...

2 Ways to remove duplicate rows in SQL? Example Tutorial

›
Hello guys, if you are wondering how to remove duplicate rows in SQL and looking for solutions on different databases like SQL Server, MySQL...

4 Examples of CASE expression in SQL

›
What is CASE and where is it used? When a condition is met, the CASE statement evaluates different conditions and returns a scalar value. Th...

Top 30 MySQL Interview Questions for 2 to 3 Years Experienced Developers

›
Hello guys, if you are preparing for MySQL interviews or you are preparing for a tech interviews where MySQL skills are needed and you are l...
Tuesday, June 3, 2025

How to find Find all tables containing column with specified name - MS SQL Server

›
Hey there! Today, we're going on a quest to uncover one of SQL Server's well-kept secrets: how to find all the tables containing a c...
›
Home
View web version
Powered by Blogger.