Why does this query return 0?

0 Answers  

---

What is a join and explain different types of joins?

2 Answers  

---

How to combine two function together?

0 Answers  

---

Explain what a database is?

0 Answers  

---

Explain about a primary key?

0 Answers  

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

0 Answers  

---

What are the constraints on severity level in raiseerror?

0 Answers  

---

State the acid rules?

0 Answers  

---

Explain the family trees and connection by clause.

1 Answers  

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  

---

how to find the first two highest salaries in deptno in emp table

2 Answers  

---