Answer / xxx

select ename, salary from
(Select ename, salary, rownum
FROM emp where rownum<=3
Order by salary )
where rownum = 1
;

What is pivot in sql?

0 Answers  

---

how to add a new column to an existing table in mysql? : Sql dba

0 Answers  

---

what are properties of a transaction? : Sql dba

0 Answers  

---

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

What is sql character function?

0 Answers  

---

what is the use of friend function? : Sql dba

0 Answers  

---

differentiate between float and double. : Sql dba

0 Answers  

---

What is a design view?

0 Answers  

---

What is the difference between inner join and left join?

0 Answers  

---

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

What is the use of triggers?

0 Answers  

---