Answer / sunita

select * from tab
where rownum=2;

From an Employee table, how will you display the record which has a maximum salary?

29 Answers   Cap Gemini, Exilant, Synechron,

---

Write a unique difference between a function and a stored procedure.

0 Answers  

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---

What is data manipulation language?

0 Answers  

---

Explain the rollback statement?

0 Answers  

---

---

Is sqlite free?

0 Answers  

---

What is bulk collect in pl sql?

0 Answers  

---

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

Can we use rowid as primary key?

0 Answers  

---

What is the use of a view in sql?

0 Answers  

---

How to combine two stored procedures in sql?

0 Answers  

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---