I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

what is a stored procedure? : Sql dba

0 Answers  

---

what is 'mysqld'? : Sql dba

0 Answers  

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

---

What does the file extension accdb stand for?

0 Answers  

---

what are dynamic queries in t-sql? : Transact sql

0 Answers  

---

What is range partitioning?

0 Answers  

---

What is field delimiter?

0 Answers  

---

What is record variable?

0 Answers  

---

What is the cause of mutating table error and how can we solve it?

0 Answers  

---

How many triggers can be applied on a table?

0 Answers  

---