Answer / Tarun Raj

1. INNER JOIN: Returns only records that have matching values in both tables. The result set includes columns from both tables, and there are no NULL values for the matched columns.
2. LEFT JOIN (also called LEFT OUTER JOIN): Returns all records from the left table (the first table in the join statement), and the matched records from the right table. If there is no match, the result set will contain NULL values on the side of the right table.
3. RIGHT JOIN (also called RIGHT OUTER JOIN): Returns all records from the right table (the second table in the join statement), and the matched records from the left table. If there is no match, the result set will contain NULL values on the side of the left table.
4. FULL OUTER JOIN: Returns all records when there is a match in either the left or right table. The result set includes NULL values for the unmatched columns.

What is the use of stored procedures?

1 Answers  

---

What is synonyms?

1 Answers  

---

can sql servers linked to other servers like oracle? : Sql dba

1 Answers  

---

Does oracle roll back the transaction on an error?

1 Answers  

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

1 Answers   Virtusa,

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

---

Why we use joins in sql?

1 Answers  

---

Does truncate table reset auto increment?

1 Answers  

---

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

---

what are the properties and different types of sub-queries? : Sql dba

1 Answers  

---

what is primary key? : Sql dba

1 Answers  

---