Waliullah Method 1: Using LIMIT (MySQL, PostgreSQL) Explanation: Method 2: Using Subquery (Works in most databases) Explanation: Method 3: Using DENSE_RANK() (SQL Server, Oracle, PostgreSQL) Explanation: For interviews, Method 2 (Subquery) and Method 3 (Window Function) are the most commonly asked.
If you are learning SQL, you might come across the term trigger. A trigger in SQL is a special type of stored procedure that automatically executes or fires when certain events occur in a database table, such as INSERT, UPDATE, or DELETE operations. Triggers are very useful for maintaining data integrity, automatically updating related tables, … Read more
In today’s world, you might have heard the term LLM or Large Language Model. But what exactly is it, and why is everyone talking about it? Don’t worry, in this article, we will explain LLM in a simple way that anyone can understand, even if you are not a tech expert. What is LLM? LLM … Read more
When learning SQL, you may hear the term SQL Stored Procedure. Many freshers get confused: Is it a function? Is it a query? Don’t worry — in this blog, we will explain what a stored procedure is, why we use it, and how it works with simple examples. What is a Stored Procedure? Example: Now, … Read more
When you start learning SQL, you often hear about Views. Many freshers get confused thinking – Are views like tables? In this blog, we will explain what are views in SQL in very simple words that any beginner in India can understand. What is a View in SQL? Example: Now whenever you use SELECT * … Read more
If you are a fresher learning SQL, you might get confused between UNION and UNION ALL. Don’t worry, in this blog we will explain the difference between UNION and UNION ALL in SQL with very simple examples that any beginner in India can understand. What is UNION? Example: This will remove duplicates and show only … Read more
Why Use Drush for Batch Process? Can run on production servers safely. No need to open the browser. Ideal for long-running batch tasks. Create a Custom Drush Command In Drupal 10, you create Drush commands inside a module in the src/Commands folder. Step 1: File Structure Step 2: Define the Drush Command @command → defines … Read more
Drupal 10 Batch Process: When working with large amounts of data in Drupal 10, running everything at once can make your site slow or even cause a PHP timeout. To solve this, Drupal provides the Batch API. The Batch Process in Drupal 10 is almost the same as Drupal 8 and 9, so if you … Read more
When building web applications in PHP, security is very important. One common but less-known attack is Host Header Injection. In this attack, a hacker changes the Host header in the HTTP request to trick your application. In this guide, we’ll learn what Host Header Injection is and how to prevent it in PHP. What is … Read more
In Drupal 10 and Drupal 11, entities (like nodes, taxonomy terms, users, or custom entities) are often linked together using entity reference fields. But what happens if you try to delete an entity that is already referenced by another piece of content? That’s why it’s a best practice to check if an entity is referenced … Read more