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
- 2248 Views
- HCL, Wipro, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is the maximum size of a row in sql server?
How to truncate a table first before running a package?
How do I view a procedure in sql server?
Explain the ways to controlling cursor behavior?
How will u test the stroded procedures and functions? difference between SP and Triggers
I have student marks in a student table. I need second highest mark .Then what will the query for this?
37 Answers NetCore, Patni, SAP Labs, Temenos, Wipro,
Do you know what is openxml in sql server?
What is temporal table?
What is difference between table aliases and column aliases? Do they affect performance?
internal language used in sql server 2000?
please differentiate between delete and truncate?
-
Oracle (3259) - 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)
