Home » SQL & PL/SQL » SQL & PL/SQL » Query to calculate working hours
Query to calculate working hours [message #223948] Mon, 12 March 2007 06:40 Go to next message
Messages: 2
Registered: March 2007
Location: bangalore
Junior Member
Can any one help me to solve this query.

I am provided with a table with fields,
Emap Id
Emp Name
Time in
Time Out

I need to calculate the total hours an employee worked in a week.

Re: Query to calculate working hours [message #223949 is a reply to message #223948] Mon, 12 March 2007 06:41 Go to previous message
Messages: 7062
Registered: December 2001
Senior Member
What are the data types of the columns?

Previous Topic: Converting to columns
Next Topic: To retrieve Table names and no of Rows in each table
Goto Forum:

Current Time: Wed Jul 26 21:45:43 CDT 2017

Total time taken to generate the page: 0.17881 seconds