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
- 2130 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Difference between 2NF &3NF ?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is the difference between truncate and delete commands?
What is a cursor in SQL Server 2000 and their types?
What are the indexes in sql server?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is the purpose of the master database?
what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?
How to get a list all databases on the sql server?
What are the underflow and overflow behaviors on float literals?
How to Check if table exists in sql server?
What is join and name different type of joins?
-
Oracle (3253) - 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)
