Answer / cbigmudre

(select * from table limit 0,1)
union
(select * from table order by Id desc limit 0,1)

Answer / 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)

Answer / ravi singh

select * from table_name
where rownum = 1
union
select * from table_name
where rownum > (select (count(1) - 1) from table_name);

I think this should work. try

What is sql data?

0 Answers  

---

How do I run a pl sql procedure in sql developer?

0 Answers  

---

Why we use sql profiler?

0 Answers  

---

please explain database architecture..

1 Answers   Infosys,

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

---

Can procedure in a package be overloaded?

1 Answers   HCL,

---

What is write ahead logging in sql server?

0 Answers  

---

How can I pass the inner procedure value to outer procedure ?

2 Answers  

---

what is transaction? : Sql dba

0 Answers  

---

What is the purpose of normalization?

0 Answers  

---

how to enter binary numbers in sql statements? : Sql dba

0 Answers  

---

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

---