how to find out the repeated value from table using groupby
function?
Answers were Sorted based on User's Feedback
Answer / arshi
SELECT COUNT(CoumnName) AS Expr1
FROM Tablename
GROUP BY CoumnName
HAVING (COUNT(CoumnName) > 1)
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / karthik
select eno,count(1) cnt from emp
group by eno having count(1) > 1;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / navin.cp
SELECT COUNT(Column_Name) FROM Table_Name WHERE (Condition)
GROUP BY Column_Name
| Is This Answer Correct ? | 0 Yes | 3 No |
How will you monitor replication latency in transactional replication? : sql server replication
List out the differences between global and local temp tables in sql server?
What is transaction server auto commit?
What is advantage data architect?
How to create an inline table-valued function?
What are tables in sql server?
what is a self join? Explain it with an example? : Sql server database administration
What are different replication agents and what's their purpose? : sql server replication
What is role playing dimension with two examples? : sql server analysis services, ssas
What are approximate numeric data types in ms sql server?
What are window functions in sql server?
What is sql view?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)