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 Collation Sensitivity ? What are the various type ?

0 Answers  

---

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,

---

how to concatenate two character strings? : Sql dba

0 Answers  

---

what is recursive stored procedure? : Sql dba

0 Answers  

---

What is package in pl sql with an examples?

0 Answers  

---

What do you mean by stored procedures? How do we use it?

0 Answers  

---

How do you modify a column in sql?

0 Answers  

---

How many tables can a sql database have?

0 Answers  

---

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

---

What is normalization in a database?

0 Answers  

---

Why truncate is faster than delete?

0 Answers  

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

---