Answer / vivek dubey

select salary_column from salary_table
where rownum<4
order by salary_column desc

How do I access sql anywhere database?

0 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

what is hash join

1 Answers   NCR,

---

define join and explain different type of joins? : Sql dba

0 Answers  

---

What is left join in postgresql?

0 Answers  

---

Why do we need a foreign key?

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

What is difference between function and trigger?

0 Answers  

---

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

0 Answers  

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

0 Answers  

---

What are stored procedures used for?

0 Answers  

---

Give me some examples of predefined exceptions.

3 Answers  

---