Stark" <[EMAIL PROTECTED]>
To: "Muhyiddin A.M Hayat" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, October 20, 2004 2:35 PM
Subject: Re: [SQL] Cross tabulations
> "Muhyiddin A.M Hayat" <[EMAIL PROTECTED]> writes:
>
> &g
"Muhyiddin A.M Hayat" <[EMAIL PROTECTED]> writes:
> Dear all,
>
> I need to do something similar to a cross tabulation, but without any
> aggregation.
join your table to itself four times:
select *
from (select check_time::date as date, employee_id, check_time-check_time::date as
in from te
Dear all,I need to do something similar to
a cross tabulation, but without anyaggregation.I have below
table id | employee_id | state
|
check_time+-+---+ 21
| 1 |
In | 2004-10-12 21:37:13 22
| 1 | Break Out |
