Category: SQL

34 posts

Difference Between DDL and DML in DBMS

In the realm of Database Management Systems (DBMS), SQL (Structured Query Language) is divided into various types of commands, each serving a specific purpose. Two primary types of SQL commands are Da... Read Mores
Prathmesh Yelne

02-Jul-2024 9:13:20

19 Views Database, SQL 3 months ago

SQL Commands | DDL, DQL, DML, DCL and TCL Commands

SQL (Structured Query Language) is a standard language for managing and manipulating databases. It includes a variety of commands grouped into different categories based on their functionality. In thi... Read Mores
Prathmesh Yelne

01-Jul-2024 10:48:00

335 Views Database, SQL, SQLite 3 months ago
avatar
Google

September 11, 2020

2.2 K Views GCP Cloud Engineer 21 hours ago

Finding the 2nd Highest Salary of Employees in SQL

Finding the 2nd highest salary in an employee database is a common SQL problem that can be approached in multiple ways. This article explores several methods, using various SQL constructs and function... Read Mores
Prathmesh Yelne

20-Jun-2024 16:40:55

41 Views Campus Interview, SQL 4 months ago

What is a Nested Field in BigQuery ?

Google BigQuery is a highly scalable, serverless data warehouse designed to enable fast SQL queries using the processing power of Google's infrastructure. One of its powerful features is the ability t... Read Mores
Prathmesh Yelne

10-Jun-2024 16:48:33

36 Views Big Data Analytics, Google BigQuery, SQL 4 months ago
avatar
Google

September 11, 2020

2.2 K Views GCP Cloud Engineer 21 hours ago

Create Function to Insert Post and Update Post in Single Function using PHP

Hello there, In this tutorial we will learn how to create function to insert post and update post in single function using core php, here's an example function that can both insert a new post and upda... Read Mores
Prathmesh Yelne

23-Mar-2023 9:12:24

53 Views MySQL, PHP, SQL 2 years ago

How to Get the Value from a key pair using PHP

Hello there, In this tutorial we will learn how to get the value from a key using PHP SQL key pair, you can use the SELECT statement in SQL and fetch the result in PHP using MySQLi. Here's an example ... Read Mores
Prathmesh Yelne

02-Apr-2023 13:58:39

113 Views MySQLi, PHP, SQL 2 years ago
avatar
Google

September 11, 2020

2.2 K Views GCP Cloud Engineer 21 hours ago

How to Store Array Data To Database to a Single Column Without serialize() & json_encode() Function

If you don't want to use serialize() or json_encode() to store the $insData array data to a single column (Key Value Pair) in a MySQL database, you can use a custom delimiter to separate the values a... Read Mores
Prathmesh Yelne

16-Mar-2024 11:21:06

89 Views MySQLi, PHP, SQL 7 months ago

How To Get the Value from a Database using PHP Key Pair

To get the value from a database using PHP key pair, you can use the SELECT statement in SQL and fetch the result in PHP using MySQLi extension. Here's an example using MySQLi: <?php // Set up dat... Read Mores
Prathmesh Yelne

02-Apr-2023 13:58:57

42 Views MySQLi, PHP, SQL 2 years ago
avatar
Google

September 11, 2020

2.2 K Views GCP Cloud Engineer 21 hours ago

How to Get All Data of Particular ID and Display using Core PHP 8

Hello Friends, In this tutorial we will learn how to retrieve data from a database using PHP 8, you can follow these general steps: Connect to the database using the mysqli_connect() function. W... Read Mores
Prathmesh Yelne

15-Mar-2023 13:01:58

48 Views MySQLi, PHP, SQL 2 years ago

How to Find the Nth Highest Salary in SQL ?

Finding the nth highest salary in SQL is a common interview question and a practical task in database management. Here are several approaches to solve this problem, each with detailed explanations and... Read Mores
Prathmesh Yelne

20-Jun-2024 17:29:50

51 Views DBMS, MySQL, SQL 4 months ago
avatar
Google

September 11, 2020

2.2 K Views GCP Cloud Engineer 21 hours ago