#DateForumTypeThreadPost
406 Jun 2016 @ 01:26 PDTDatabaseTopicHow to get first date of last month based on max date from another table?Hi all, I have a query to get the first date of last month SELECT ADD_MONTHS(DATE'2016-04-01' - EXTRACT(DAY FROM DATE'2016-04-01') + 1,-1)   >>'2016-03-01' Th...
325 May 2016 @ 09:15 PDTDatabaseTopicLeft join and filter NULL doesnt work!Hi, i have 2 tables Table 1 colA colB colC A1 A2 A3 B1 B2 B3   Table 2 colA colB colC A1 C2 C3 D1 D2 D3   Table 1 left jon Table 2 on colA colA colB colC colAA colBB colCC A1...
218 Nov 2009 @ 02:19 PSTUDATopicWhich "select..from..where" syntax is running faster?Hi, i am wondering from the 2 syntax below, which is running faster or is the best practice?First option==========Select A.Col1,B.Col1,A.Col2,A.Col3From(Select Col1, Col2,Col3From Table1) ALeft joi...
105 Nov 2009 @ 03:04 PSTUDATopicHow to add in Select Statement inside Case?I have 2 table with below dataManager_ID | Manager_Name | COMPANYCARE | ANDY | COMP ACARE | JOHN | COMP BCARE | CHRIS | COMP CA001 | ANDY | COMP DA002 | MABEL | COMP EA003 | LANDY |COMP FMANAGER_ID...