How to divide query output into multiple groups with the group by clause in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What is cursors? And what are the different types of cursor?
Explain SELF JOIN ?
What is the usage of the sign function?
Explain what is dbcc?
What is the cartesian product of the table?
Explain the concept of recursive stored procedure.
Display a roll having miminum marks in two subjects?
How to insert new line characters into strings?
What is failover clustering overview?
Define the one-to-one relationship while designing tables.
What is the maximum size of column in sql server?
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
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)