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
- 2292 Views
- HCL, Wipro, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the use of tempdb? What values does it hold?
What is an inner join?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
How do I delete a sql server database?
What is plan freezing?
What are the essential components of sql server service broker?
Can we create a clustered index on composite primary key.
What is the difference between cube operator and rollup operator? : SQL Server Architecture
Difference between primary key and clustered index?
What are the authentication modes in sql server? How can it be changed?
What is an indexing technique?
What do you mean by collation recursive stored procedure?
-
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)
