Answer Posted / gourav

select * from employees
where employee_id=100
union
select* from employees
where employee_id=206;


Example

first coulumn_ id(100)
last column _id(206)

What is attribute indicator in pl sql?

1015

---

How do I partition a table in sql?

1131

---

What is the difference between delete and truncate statement in sql?

1070

---

what is the difference between truncate and delete statement? : Transact sql

1064

---

What are the string functions in sql?

976

---

What is the difference between inner join and natural join?

1006

---

what is rollback? : Sql dba

1111

---

What is use of trigger?

933

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1004

---

Which are sql * plus commands?

1130

---

State few characteristics of pl/sql?

971

---

What are the methods of filing?

935

---

What is schema in sql?

949

---

What is a pl/sql block?

1230

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1040

---