what is a trigger in mysql? : Sql dba

0 Answers  

---

what is HASH join?

2 Answers   Genpact, HCL,

---

How to find 3rd highest salary of an employee from the employee table in sql?

0 Answers  

---

Write a query to get last 10 records from the table.

12 Answers   iNautix,

---

what is a database? : Sql dba

0 Answers  

---

---

How many parts of a pl sql block are optional?

0 Answers  

---

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

What is type and rowtype in pl sql?

0 Answers  

---

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  

---

what is the difference between pragma exception_init and raise_application_error

1 Answers   Aetins, State Street,

---

explain the difference between bool, tinyint and bit. : Sql dba

0 Answers  

---

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

---