Interested to Buy Any Domain ? << Click Here >> for more details...
I have a table Events Events containing cardno,time,id,name-
-each id has a cardno my requirement is every day each
employee swipe the card several times i want to calculate
first and last time of each card the output should be name 1
2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40
06:45 where 1,2...... are dates for example january 1,2,
etc. 6 and 7 are saturday and sunday how it is posssible
- 0 Answers
- 2099 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What are the functions in sql server?
What is Cross Join
What is the library index called?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
How to verify the port number of the sql server?
what is denormalization? : Sql server database administration
What is the default order of an order by clause?
what is a schema in sql server 2005? : Sql server database administration
How can sql injection be stopped? : sql server security
What are the purpose of Normalisation?
What is the process of indexing?
When do u use clustered index and non-clustered index?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
