# | Date | Forum | Type | Thread | Post |
4 | 06 Jun 2016 @ 01:26 PDT | Database | Topic | How 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... |
3 | 25 May 2016 @ 09:15 PDT | Database | Topic | Left 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... |
2 | 18 Nov 2009 @ 02:19 PST | UDA | Topic | Which "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... |
1 | 05 Nov 2009 @ 03:04 PST | UDA | Topic | How 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... |
|
|