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
- 2103 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is page-level compression?
what is DTS what are tasks available
please tell me the query to get details of the employee having the second largest salary
Can multiple columns be used in sql group by clause in ms sql server?
What is a field in a table?
What is correlated subquery in sql server?
What is the use of RDBMS?
Can we rewrite subqueries into simple select statements or with joins? Example?
Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?
what is the difference between a primary key and a unique key? : Sql server database administration
Can a database be shrunk with users active?
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?
-
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)
