Tags for subquery
optimisation of a query with TRIM function
hello everyone.   i have an INSERT query with a subquery like this one:   SELECT 1               FROM SD_CRM.D_INDIV_PREF DIP               WHERE DIP.SITE = FPL.SITE                   AND  TRIM(DIP.ID_CLIENT) = TRIM(FPL.ID_CLIENT)  
optimisation trim subquery
Correlated SubQuery needs Tuning.. INDEX and LENGTH functions causing problem...
Hi All I have two tables like below with sample data:  ACCNT_TABLE    |   REF_TABLE    ID_COL            |     REF_COL     123                  |     Desc_123     100                  |     200_payout
query tuning subquery index function product join
Correlated SubQuery needs Tuning.. INDEX and LENGTH functions causing problem
Hi All, I have scenario like below: Requirement - Need to select ID values those are present ( hidden)  in DESCR column. But no joining condition in both the tables.Query I have used -
subquery query tuning index function Search for first substring in string product joi with condition
Count of Records within 7 days of Timestamp
Hello,
count timestamp date interval subquery
Period-to-Date Values without CTE or Subquery
I'm curious to see if there is a way to get period-to-date values (e.g. WTD, MTD, QTD, YTD) without using a CTE or subquery. Here is an example query using a CTE:
sql cte subquery