In this post, we will be discussing the most frequently used admin commands specifically the SHOW commands. SHOW is a command that displays information about
Category: RDBMS
SQL Server String Functions-6
A string function accepts a string value as an input and returns a string value regardless of the data type. They’re used to convert an
SQL Server String Functions-5
A string function accepts a string value as an input and returns a string value regardless of the data type. They’re used to convert an
Multi Group_Concat in a single query with Distinct – MySQL
The CONCAT() function joins the input strings or different column values and returns as a single string. However, if we need to concatenate rows of
List tables in PostgreSQL
Unlike MySQL, Apache Hive, and Apache Impala, we can’t acquire a list of tables in PostgreSQL using the SHOW TABLES command. Use the below command
PostgreSQL – Grant Permission on Database
After a long time, when I tried to create a user and grant him all permissions on a certain database using- GRANT ALL PRIVILEGES ON
Big Data & SQL 