#DateForumTypeThreadPost
406 Jan 2014 @ 12:07 PSTDatabaseReplySQL helpDieter, Actually it worked.. I gave GROUP BY 1,2,3,4,5
306 Jan 2014 @ 11:50 PSTDatabaseReplySQL helpDieter, I tried and iam getting this error. Failed 3504 I am getting selected non-aggregrated values must be part of associated group.   SELECT acct_id, MRCH_NM, EXTRACT(YEAR FROM trxn_po...
205 Jan 2014 @ 08:40 PSTDatabaseReplySQL helpThanks Dieter, Wil try and post you the update..  
104 Jan 2014 @ 05:21 PSTDatabaseTopicSQL helpHi gurus, I am trying to generate a sql based on this scenario. please suggest how. i have a table with credit card number, transaction date and amount and merchant. I want to find a creditcard num...