Can we use having clause without group by?

0 Answers  

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---

What are the different types of backups that exist?

0 Answers   ADITI,

---

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

---

What is page in sql server?

0 Answers  

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

0 Answers  

---

Magic Tables ?

2 Answers   Thomson Reuters,

---

ehat is the default port no of sql 2000?

2 Answers   IBM,

---

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

---

select empid empname from employee What is the result for the about query?

4 Answers  

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---