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
- 2215 Views
- HCL, Wipro, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what changed between the previous version of sql server and the current version? : Sql server database administration
I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.
Difference between uniqe index and uniqe constraint?
how to know description of a table in sqlserver 2000
How to change the name of a database user?
Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?
What is Cross Join
what is the difference between Delete and Truncate
4 Answers CarrizalSoft Technologies, Geo Research Centre,
How do I create a stored procedure in dbml?
How to view existing indexes on an given table using sp_help?
What are sp_configure commands and set commands?
What is the significance of master, tempdb and model databases?
-
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)
