I've got a table containing some timesheet data.
Fields are emp, earncode, lo_shift, hi_shift.
SELECT emp, sum(hi_shift - lo_shift) as reghrs from timesheet
where earncode in ('R', 'C', 'X') order by emp
will give me all the regular hours
SELECT emp, sum(hi_shift - lo_shift) as ovrhrs from timesheet
where earncode not in ('R', 'C', 'X') order by emp
will give me all the overtime hours.
How do I combine these to get one result set with emp, reghrs, ovrhrs on
1stUp.com - Free the Web
Get your free Internet access at http://www.1stUp.com
pgsql-sql by date
|Next:||From: Palle Girgensohn||Date: 2000-09-11 13:51:23|
|Subject: Re: need asap: bg_BG locale for FreeBSD|
|Previous:||From: Trewern, Ben||Date: 2000-09-11 12:27:48|
|Subject: Tree structure|