Do you need to get the top rows in an SQL query?
Do you need to perform pagination, or find the top 5 or 10 results from a query?
You can do that in SQL using a “row limiting” feature.
Learn how to use this SQL limit feature in this article.
Are you looking for the best way to learn SQL?
Are you unsure where to begin?
The good news is that there are a lot of SQL tutorials online. There are many ways to learn SQL that are suitable for different people. Some people like reading articles or books, others like watching videos. Some have exercises, some have a practice SQL sandbox, some don’t.
This list contains over 50 different places to learn SQL. Take a look at the list and find one that looks good to you!
Subqueries are powerful features of SQL.
If you want to move beyond the basics of SQL, then subqueries are something you need to know about.
This article will show you everything you need to know about subqueries in SQL.
There are many good books for programmers outside of those that teach how a certain technology or programming language. I’ve listed some I’ve read in this article.
This is a common feeling. To break through this needs successful and effective time management. I’ve listed a lot of different time management tips that software developers can use to get the most out of their day.
Communication skills are an important part of your career as an IT professional. Learning how to have effective communication in the workplace in this article.
Installing an Oracle database on a Mac computer is a bit different to installing it on a Windows or Linux computer.
If you’re running a MacBook (like I am), or any type of Mac, this article will be useful for you. You’ll see the step-by-step instructions to install Oracle on a Mac.
ODC Appreciation Day is a roundup of blog posts by Oracle database blog owners on their favourite features of SQL Developer and other Oracle technologies.
For this year, my appreciation is for Oracle Live SQL.
As programmers, we should be always looking to improve our skills and how we do our job.
In this article, I’ve shared a range of tips on how to improve programming skills, which I hope you can benefit from!