What happens if null values are involved in comparison operations?

0 Answers  

---

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

3 Answers   NIIT,

---

Why do we need normalization?

0 Answers  

---

Explain what is the function of sql server agent windows service?

0 Answers  

---

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,

---

What part does database design plays a role in performance of an sql server-based application?

0 Answers  

---

How you can find out if an index is useful to the optimizer?

0 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

What is data file in computer?

0 Answers  

---

What are the disadvantages of primary key and foreign key in SQL?

0 Answers   Alcatel-Lucent,

---

How many .ndf files can we create in Sql server 2005?

2 Answers   Wipro,

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---