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
- 1651 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Explain the microsoft sql server delete command?
what are user defined datatypes and when you should go for them? : Sql server database administration
Explain about system database?
How to download and install microsoft sql server management studio express?
A left outer join B B right outer join A gives the same result then what is the use of two?
Characterize join and name diverse sorts of joins?
What is an example of a primary key?
wat wil hapn if we give the both read and deny read permission to user?
What is identity?
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
What is acid properties?
How you can change the database name in SQL SERVER?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
