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
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
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
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
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
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
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
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
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
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
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago