how to find out the repeated value from table using groupby
function?
- 4 Answers
- 6492 Views
- I also Faced
- E-Mail Answers
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 |
Differentiate between a local and a global temporary table?
Is it possible in sql table to have more than one foreign key?
Explain the properties of sub-query in sql server?
What are different types of raid configurations? : SQL Server Architecture
what is differece between union and union all
can you any body tell me suppose database is suspect mode. how can take to normal?
If there is failure during updation of certain rows, what will be the state?
How to declare and use cursor variables?
What are translations and its use? : sql server analysis services, ssas
How do you trace the traffic hitting a sql server?
Explain the different index configurations a table can have?
What is a non equi join?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
