What is partition by in sql?

0 Answers  

---

What are the possible values that can be stored in a boolean data field?

0 Answers  

---

Is primary key an index?

0 Answers  

---

What is sql entity?

0 Answers  

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

---

What is the use of sqlerrd 3?

0 Answers  

---

Define the select into statement.

0 Answers  

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---

What is the diffrence between IN and EXISTS.which one is faster.

3 Answers   Infogain,

---

What are the basic techniques of indexing?

0 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

---