How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 Answers  

---

what is called after appearing where clause

3 Answers  

---

Can we use rowid as primary key?

0 Answers  

---

Is it possible to access the current value in a session before accessing next value?

1 Answers  

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

Can you have more than one trigger on a table?

0 Answers  

---

what is the bond code in materialized view?

0 Answers  

---

How to make a copy values from one column to another in sql?

0 Answers  

---

What is duration in sql profiler trace?

0 Answers  

---

What is the use of function "module procedure" 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 are sql functions? Describe in brief different types of sql functions?

0 Answers  

---