select E.some column names,F.some column names
from (select D.some column names,C.column names
from <table name> as C, (select A.some column names,B.some column names )as D)as E, <table name> as F.
Is the above query correct ?
erebus
Last Activity: Oct 12 '07, 11:17 AM
Joined: Sep 25 '07
Location:
-
o check spaces in db2
Do we have any in-built functions to check spaces in db2? e.g: ISSPACES() checks for spaces in informatica. -
count on aggregate function
Consider an employee table which contains following columns
employee_id
employee name
salary
account_id
carrier_id
employer group_id
I need to find the sum of salaries grouped by account_id,carr ier_id,employer _group_id.Hope it gets grouped as records having distinct combinations of above mentioned columns(correct me if i'm wrong). I need to find the count of these... -
getting prevoius day's date in a query?
could anybody help me in getting the previous day's date in a query:
In sql analyzer, the query "select getdate()-1" returns the previous day's date!
do we have a db2 equivalent of the above mentioned query. -
can space be provided as a value in the column (of database) ?
Can we have spaces as values in the columns of database ?
If so, are they equivalent to null values ? -
Does count(sum()) function work in ibm iseries navigator ?
Consider an Employee table with columns employee id , employee name, salary, department name and department number.
We need to find “count” of the aggregate function, say sum of salary, grouped by department name and employee name !!!
The following query
"Select count(sum(salar y)) from employee where ....(some condition) group by department name, employee name".
fails in IBM iseries navigator...
No activity results to display