| From: | "Vijay Uppal" <vijay25(at)telus(dot)com> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | sql query |
| Date: | 2002-12-04 02:03:22 |
| Message-ID: | 000001c29b39$5397e5a0$6501a8c0@bc.hsia.telus.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi I have a problem forming a query
I have 3 tables salary(hrs, clock_in , clock_out)
Break ( date, employe_id, net_time, break_in, break_out)
Employee(employee_id, pay_rate, name)
I need to get an hourly report till the current time for that day
stating name, hour, no of hours, salary
Example
Rob 3-4 48min $6.56
Min 2-3 23min $2.34
Min 3-4 54min $7.67
And so on..Would appreciate help on this.since I cant come up with the
query
Vj
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vernon Wu | 2002-12-04 05:22:37 | Re: How does postgres handle non literal string values |
| Previous Message | eric soroos | 2002-12-03 20:52:04 | Re: Query for filtering records |