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
- 2050 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is data source in connection string?
Do you know what are the reporting services components?
What are the advantages of using views. Why do we need views when we have SPs?
What does it mean if @@cursor_row returns a negative number?
Is natural join and equi join same?
Can you name some of the dml commands in sql?
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
What happens if null values are involved in boolean operations?
Explain what are the events recorded in a transaction log?
What is spatial and temporal data?
Explain different types of collation sensitivity?
How many primary keys are possible in a table?
-
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)
