SQL SQL 43 Questions SQL Ask question Search Order By: ActiveTagClear Filter 0 Votes 1 Ans How can you troubleshoot slow SQL queries? 1.24K viewsAlejandro Penzini Answered question October 30, 2023SQLSql 0 Votes 1 Ans What are some common SQL performance tuning techniques? 1.15K viewsAlejandro Penzini Answered question October 30, 2023SQLSql 0 Votes 1 Ans What are the different types of ACID properties and how do they ensure data integrity? 1.47K viewsAlejandro Penzini Answered question October 30, 2023SQLMysql Sql 0 Votes 1 Ans What is an index and why is it important? 1.45K viewsAlejandro Penzini Answered question October 30, 2023SQLSql 0 Votes 1 Ans What is a window function and how is it used? 1.13K viewsAlejandro Penzini Answered question October 30, 2023SQLSql 0 Votes 1 Ans What is a common table expression (CTE) and how is it used? 1.45K viewsAlejandro Penzini Answered question October 30, 2023SQLSql 0 Votes 1 Ans What is a view, and how is it created? 1.22K viewsAlejandro Penzini Answered question October 30, 2023SQLSql 0 Votes 2 Ans What is an aggregate function, and what are some common examples? 1.52K viewsAlejandro Penzini Answered question October 30, 2023SQLSql 0 Votes 1 Ans What is a join, and what are the different types of joins? 1.73K viewsAlejandro Penzini Answered question October 30, 2023SQLSql 0 Votes 1 Ans What are the different SQL statements used to create, read, update, and delete data? 1.16K viewsAlejandro Penzini Answered question October 30, 2023SQLSql 0 Votes 1 Ans What are the different data types in SQL? 1.29K viewsAlejandro Penzini Answered question October 30, 2023SQLSql 0 Votes 1 Ans What is the difference between a database and a table? 5.67K viewsAlejandro Penzini Answered question October 30, 2023SQLSql 0 Votes 1 Ans How do you flatten XML in the snowflake database? 8.26K viewsAlejandro Penzini Changed status to publish July 4, 2023SQL 0 Votes 1 Ans How can I repeatedly run a stored procedure in the snowflake database? 7.33K viewsAlejandro Penzini Changed status to publish July 4, 2023SQL 0 Votes 1 Ans How do I setup Autonumbers in Snowflake? 7.68K viewsAlejandro Penzini Changed status to publish July 4, 2023SQL 0 Votes 1 Ans How can I get the identity of the last row inserted into the snowflake database? 10.64K viewsnam_rata Posted new comment May 16, 2024SQL 0 Votes 1 Ans Do snowflake UDFs allow recursion? 6.75K viewsAlejandro Penzini Changed status to publish June 30, 2023SQL 0 Votes 1 Ans SQL to get the time difference? 7.24K viewsAlejandro Penzini Changed status to publish June 30, 2023SQL 0 Votes 0 Ans How does rollback work in snowflake? 6.68K viewsDaniel Steinhold Answered question April 25, 2023SQL 0 Votes 1 Ans Can you perform nested queries in snowflake? 9.61K viewsGisele Casillas Answered question January 22, 2022SQL « Previous 1 2 3 Next »
