How to test subquery results with the exists operator?

0 Answers  

---

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  

---

What are constraints in microsoft sql server?

0 Answers  

---

What does null mean?

0 Answers  

---

Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

---

---

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

---

Can you explain what is indexed view? How to create it?

0 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

---

What is row_number () and partition by in sql server?

0 Answers  

---

What are the various editions of sql server 2017 that are available in the market?

0 Answers  

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,

---