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
- 1736 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Can sql servers link to other servers?
What is a field in a table?
What is difference between table aliases and column aliases? Do they affect performance?
Do you know what guidelines should be followed to help minimize deadlocks?
What are different types of views?
difference between truncate, delete aur drop?
Explain full-text indexing?
What is difference statement and preparedstatement?
How many types of triggers are there?
explain the storage models of olap? : Sql server database administration
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Tell me can we use custom code in ssrs?
-
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)
