Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Priyanka Gupta
3 articles
Selecting Multiple Columns Based On Condition in SQL
Selecting Multiple Columns Based On Condition Structured Query Language is used to manage and query databases. One common use case of databases is to select single columns or multiple columns of a table based on specific conditions. The SQL SELECT statement is used to retrieve data from a database. These conditions help filter the data to match your query. These conditions are : AND and OR IN BETWEEN Syntax Following is the syntax for selecting multiple columns is − SELECT col 1 , col ...
Read MoreMethods to avoid the SQL divide by zero error
In SQL, performing division operation sometimes leads to errors when divided by zero . This error is " divide by zero " which can disrupt your query execution . To avoid this situation, we can use the following methods: Use NULL IF function Use CASE statement Use SET ARITHABORT OFF Use WHERE Now we will discuss these methods one by one with the help of examples. Use NULLIF function In this method , if both the arguments are ...
Read MoreHow to Connect to Mysql Server Using VS Code and Fix errors?
MySQL is a relational database based on Structured Query Language used to access and manage records in a database. MySQL is based on a client-server architecture that follows a request-response cycle. Clients make requests through GUI or command prompt using MySQL. Fixing Errors in MySQL Server Here are the steps to connect to the MySQL Server using VS Code - Open Visual Studio code. Go To -> extensions, search MySQL Open the extension called MySQL management tool and install it. Click on the ...
Read More