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

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---

What is the difference between 2-Tier architecture and 3-Tier architecture

15 Answers   CTS, MCN Solutions, Oracle,

---

What is the difference between referencing and joining?

1 Answers  

---

What is mean by "fill factor" ? and what is mean by "Index "in sql?

1 Answers   iGate, Logica CMG,

---

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

---

How to add code to the existing article (using improve article)?

0 Answers  

---

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

---

Explain the benefits of user-defined functions?

0 Answers  

---

When to use Inner join & when to use subquery?

0 Answers   IBM,

---

How to defragment table indexes?

0 Answers  

---

What is de-normalization in sql database administration? Give examples?

0 Answers  

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---