Answer / Ankur Jain

In SQL, a JOIN clause is used to combine rows from two or more tables based on a related column between them. This allows you to retrieve data that spans multiple tables while maintaining their relationship. There are four main types of joins: INNER JOIN (returns only the matching rows), LEFT OUTER JOIN (includes all the records from the left table and the matching records from the right table), RIGHT OUTER JOIN (includes all the records from the right table and the matching records from the left table), and FULL OUTER JOIN (includes all the records when there is a match in either the left or the right table).

How to automatically create a log when an exception is being received into SQL Server?

1 Answers   Cap Gemini,

---

What is key set driven?

1 Answers  

---

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1 Answers  

---

Why it is recommended to avoid referencing a floating point column in the where clause?

1 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

1 Answers   HCL, Wipro,

---

What is Replication?

1 Answers  

---

How to include date and time values in sql statements?

1 Answers  

---

What is reference section?

1 Answers  

---

What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,

---

what is an extended stored procedure? : Sql server database administration

1 Answers  

---

What is the security principal at the server level that represents your session?

1 Answers  

---