Total Page Preview: 000000001709
What is concat function in SQL in English and Hindi
Concat function in English
In SQL, CONCAT function is used to concatenate two or more strings together. It takes two or more string expressions as input and returns a single string that contains all the input strings concatenated together.
The basic syntax of the CONCAT function is as follows:
Here is an example of the CONCAT function in SQL:
Suppose we have a table called "Employees" with the following data:
If we want to concatenate the First_Name and Last_Name columns to create a full name column, we can use the CONCAT function as follows:
The result of the above query would be:
As you can see, the CONCAT function has concatenated the First_Name and Last_Name columns and added a space in between to create a full name column.
Concat function in Hindi
SQL mein CONCAT function ka upyog do ya adhik strings ko ek saath jodne ke liye kiya jata hai. Ismein do ya adhik string expressions ko input ke roop mein liya jata hai aur ek hi string return kiya jata hai jo sabhi input strings ko ek saath joda hua hota hai.
CONCAT function ka basic syntax is tarah hota hai:
Yahan SQL mein CONCAT function ka ek example diya gaya hai:
Maan lijiye hamare paas "Employees" naam ka ek table hai jismein niche di gayi data hai:
Agar hum First_Name aur Last_Name columns ko ek full name column mein jodna chahte hain, to hum CONCAT function ka upyog is tarah se kar sakte hain:
Is query ka result niche diya gaya hai:
Jaisa ki aap dekh sakte hain, CONCAT function ne First_Name aur Last_Name columns ko ek saath jodkar ek full name column banaya hai. Ismein ek space bhi joda gaya hai.
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com