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
- 1986 Views
- HCL, Wipro, I also Faced
- E-Mail Answers
Write the Syntax for Cursors.
2 Answers CarrizalSoft Technologies, HP,
What is indexing explain it with an example?
What is the query optimization statistics?
What is model database? : SQL Server Architecture
What is the default server name for sql server?
What is sql sandbox in sql server?
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.
What are the different types of join?
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?
What is difference between view and materialized view?
What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.
What is meant by Active-Passive and Active-Active clustering setup?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
