1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / madhuri

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

You want to implement the one-to-one relationship while designing tables. How would you do it?

1 Answers  

What is nonclustered index with included columns ?

1 Answers  

How to move database physical files in ms sql server?

1 Answers  

In which format does an image save in SQL Server database ?

1 Answers   MCN Solutions,

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

1 Answers  

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

can a table be moved to different filegroup? : Sql server administration

1 Answers  

What is the parse query button used for?

1 Answers  

What does dml stand for?

1 Answers  

Find first and last day of current month in sql server

1 Answers  

Is natural join and equi join same?

1 Answers  

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories