SQL

Keep your SQL sorted with Common Table Expression (CTE)

Hi guys, hope y’all doing good. Now that everything has started to become normal and the way how it was actually, there are still...
Ram Prasanna
2 min read

How To Enable MySQL For Remote Access

We started using Qlik Views for our customers and we were in need of connecting to remote MySQL server for Data analytics. By default...
Sivakumar V
1 min read

Differences between Stored procedures and User Defined Functions

Stored Procedure: A Stored procedure is a set of sql statements with a given name , which is physically stored in database in the...
Nageswar P
1 min read