I want to query a table which has date time stamps and want to sum on a column to give the results per day is there a function to do this?
for example my data is
Order no order sold d...
http://www.experts-exchange.com/Database/DB2/Q_21963232.html
Zones:
DB2Date Answered: 09/24/2006 Grade: A Views: 0
I need some objective advice. I have been a SQL Server DBA/Developer and an Oracle DBA/Developer for a number of years, and of course I'm biased toward (especially) SQL Server.. My IT Director as...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2261...
creating update subquery to update ALL agt within table that meet criteria
tried below & got error message - more one row satify condition
how would this be done?
attached file with sample data...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23193677.html
Zones:
SQL Syntax,
DB2Date Answered: 03/09/2008 Grade: B Views: 0
I have to develop a system that communicates between a windows client with a SQL05 cache backend and DB2 as the long term backend.
Where can I find more about getting DB "documentation" for DB2/A...
http://www.experts-exchange.com/Programming/System/AS_-_400/Q_23242431.html
My previous question was mostly solved by using MAX values to look up single value columns.
However there is a result needed which may REALLY need some sort of sub-query. Please excuse this long-w...
http://www.experts-exchange.com/Database/DB2/Q_23571280.html
Zones:
DB2,
AS / 400Date Answered: 07/17/2008 Grade: A Views: 0
Hi all,
I have a transaction table that stores date and time in different fields. I need to concatenate these 2 fields and then subtract the minimum from the maximum to see how much time was bet...
http://www.experts-exchange.com/Database/DB2/Q_23582735.html
Zones:
DB2Date Answered: 07/21/2008 Grade: A Views: 46
I have a query with 14 self joins that I developed to remove detail on control#'s that sum to zero. Control numbers that don't sum to zero I still want to see all the detail so aggregation is out I...
http://www.experts-exchange.com/Database/DB2/Q_23851770.html
Zones:
DB2Date Answered: 10/27/2008 Grade: A Views: 5
Hi All,
I have a situation where I want to mask an employeeID column in a database (DB2). I want the data stored on the database to remain 'in-the-clear', but I want to be able to create a SEL...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23865703.html
My table in DB2 is like that
SR_NO EMP1 EMP2
-------- ------- -------
01 JOHAN KITTY
02 JOHAN PREETY
03 KITTY PETER
04 ...
http://www.experts-exchange.com/Database/DB2/Q_21874532.html
Zones:
DB2Date Answered: 10/05/2006 Grade: A Views: 36
This question has been asked before, but the answer was not only poorly answered, but the provided link is now dead.
I need to insert a PDF into a BLOB field in an AS/400 DB2 Database using SQL em...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/...
