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
krishnasv
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
Date
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
Maaher
Messages: 7062
Registered: December 2001
Senior Member
What are the data types of the columns?

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


Current Time: Tue Dec 06 06:26:24 CST 2016

Total time taken to generate the page: 0.10591 seconds