Sumit goyalDB2 SQL GLOBAL TEMPORARY TABLEDECLARE GLOBAL TEMPORARY TABLE gives you a handy option to create a table in QTEMP lib with some handy options.1 min read·Jul 21, 2021----
Sumit goyalDB2 SQL BASIC — 1Structured Query Language aka SQL is the industry standard to talk to Relation database management systems (RDBMS). RDBMS and SQL are like…3 min read·Jul 21, 2021----
Sumit goyalDB2 SQL CURSOR : POSITIONED UPDATE & DELETEWhen processing a CURSOR, DB2 SQL gives the option to update or delete data in the base table based on CURSOR's current position in the…3 min read·Jul 21, 2021----
Sumit goyalDB2 SQL CURSORThe result of a SELECT Statement which returns more than one row, is easy to view on an SQL interface like STRSQL. But How can we handle…6 min read·Jul 21, 2021----
Sumit goyalDB2 SQL FIND nth HIGHEST NUMBER.We can use a very simple correlated query to find the nth highest or lowest record in a table.1 min read·Jul 21, 2021----
Sumit goyalDB2 DYNAMIC SQLThere are two ways to write SQL: Static SQL, which gets the job done in most cases, and the second one is Dynamic SQL for the rest of the…5 min read·Jul 21, 2021----
Sumit goyalDB2 SQL DELETE DUPLICATE DATA FROM THE TABLE.There are multiple ways to Delete duplicate data from A Table using SQL Query. Here we are going to talk about using Correlated subqueries…2 min read·Jul 7, 2021----