Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
chriys1337
Creator III
Creator III

SELECT vs. SQL SELECT

Hi,

I am retrieving data from a snowflake database and I recognized that SELECT works but also SQL SELECT.

 

So I am questioning what is the difference? Is there one?

 

Thanks a lot for your help.

 

 

Labels (1)
1 Solution

Accepted Solutions
Benoit_C
Support
Support

Hello @chriys1337,

There is no difference, in Qlik Sense, both “SELECT” and “SQL SELECT” are used to retrieve data. The SQL prefix will remain optional for SELECT statements: 
https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

Regards,
Benoit

View solution in original post

2 Replies
Benoit_C
Support
Support

Hello @chriys1337,

There is no difference, in Qlik Sense, both “SELECT” and “SQL SELECT” are used to retrieve data. The SQL prefix will remain optional for SELECT statements: 
https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

Regards,
Benoit

Prem0212
Creator
Creator

In Snowflake, the SQL language is used to interact with the database, and "SELECT" is the SQL keyword used to retrieve data from tables.
so we can use both