Answer / Anshu Sharma

SQL JOIN is a set operator that combines rows from two or more tables, based on a related column between them. It can be INNER JOIN (only returns matching rows), LEFT JOIN (returns all rows from the left table and matching rows from the right table), RIGHT JOIN (returns all rows from the right table and matching rows from the left table), or OUTER JOIN (a combination of LEFT and RIGHT join).

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

---

What are pl sql data types?

1 Answers  

---

What does subquery mean in sql?

1 Answers  

---

What is a call statement? Explain with an example.

1 Answers  

---

Can you have a foreign key without a primary key?

1 Answers  

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,

---

Why do we use joins?

1 Answers  

---

What are all the different normalization?

1 Answers  

---

What is sql and how does it work?

1 Answers  

---

What are the topics in pl sql?

1 Answers  

---

What is crud sql?

1 Answers  

---