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  

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

How to create a new table in a given schema?

0 Answers  

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

What is merge replication?

0 Answers  

---

---

Do you know what is lock escalation?

0 Answers  

---

Advantages and Disadvantages of Cursor?

15 Answers   Polytechnic, TCS, Zenith,

---

Benefits of Stored Procedures?

0 Answers   Wipro,

---

How many types of the database links?

0 Answers   MCN Solutions,

---

What is the server name for sql management studio?

0 Answers  

---

Which command is used for user defined error messages?

0 Answers  

---

What are rows and columns?

0 Answers  

---