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
- 2132 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is normalization? What number of normalization shapes are there?
How to drop an existing table with "drop table" statements in ms sql server?
What is the difference between mysql and mysqli?
what are the main differences between ms access and sqlserver
what is the difference between Delete and Truncate command in SQL
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
What happens if an integer is too big for int date type?
What is normalization?
Can we use pragma autonomous_transaction in trigger?
what is a stored procedure and trigger?
What is Lock table in SQL?
What is the purpose of grouping data in a report?
-
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)
