What is trigger types in sql?

0 Answers  

---

How do I make my sql query run faster?

0 Answers  

---

what is a stored procedure? : Sql dba

0 Answers  

---

Advantages and disadvantages of stored procedure?

0 Answers  

---

how to create table with in the procedure or function?

2 Answers   Genpact, HCL,

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers  

---

how to concatenate two character strings? : Sql dba

0 Answers  

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

---

explain mysql aggregate functions. : Sql dba

0 Answers  

---

Can we perform dml on view?

0 Answers  

---