Answer / arshi

SELECT COUNT(CoumnName) AS Expr1
FROM Tablename
GROUP BY CoumnName
HAVING (COUNT(CoumnName) > 1)

Answer / karthik

select eno,count(1) cnt from emp
group by eno having count(1) > 1;

Answer / vishu

by using count(colun name ) and differd calumn

Answer / navin.cp

SELECT COUNT(Column_Name) FROM Table_Name WHERE (Condition)
GROUP BY Column_Name

Can binary strings be converted into numeric or float data types?

0 Answers  

---

How to Rebuild Master database in sql server 2005.

2 Answers   Wipro,

---

What are character string data types in ms sql server?

0 Answers  

---

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

1 Answers   Idea,

---

What do you understand by a view?

0 Answers  

---

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

---

Explain about Views?

0 Answers   Infosys,

---

how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,

---

How to make a remote connection in a database?

0 Answers  

---

How to set database to be read_only in ms sql server?

0 Answers  

---

Do you know what is a trace frag? Where do we use it?

0 Answers  

---