Answer / Rajesh Kumar Verma

A natural join is similar to an Inner Join since it only returns matching rows and doesn't include any null values from either table.

how to findout the 100th maximum salary

28 Answers   Amdocs,

---

Enlist some predefined exceptions?

1 Answers  

---

List different type of expressions with the example.

1 Answers  

---

What is a constraint? Tell me about its various levels.

1 Answers  

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

Which operator is used in query for pattern matching?

1 Answers  

---

What operating systems are supported by oracle sql developer?

1 Answers  

---

What is PL/SQL Records?

1 Answers  

---

what is offset-fetch filter in tsql? : Transact sql

1 Answers  

---

Which is faster truncate or drop?

1 Answers  

---

which tcp/ip port does sql server run on? : Sql dba

1 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,

---