Temporary table vs Table variable in sql server?

0 Answers   Wipro,

---

Write a query to find the names of users that begin with "um" in sql?

0 Answers  

---

Is not null in sql?

0 Answers  

---

How is data stored on a disk?

0 Answers  

---

State some properties of relational databases?

0 Answers  

---

What is the difference between union and union all command?

0 Answers  

---

How do you write a subquery?

0 Answers  

---

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,

---

what is the use of double ampersand (&&) in sql queries?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

Is pl sql useful?

0 Answers  

---

what is called after appearing where clause

3 Answers  

---