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

how to find out the repeated value from table using groupby
function?

Question Posted / karthik

Answer Posted / karthik

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is b tree index?

867

What is a primary key?

915

What is the security model used in sql server 2005?

953

Define left outer join?

936

What command must you use to include the not null constraint after a table has already been created?

1076

what is hash nonclustered index

922

What is join and name different type of joins?

997

How many databases can we create in a single server?

205

What is the maximum size of a row in sql server?

930

Can sql servers linked to other servers like oracle?

914

What is data source view or dsv? : sql server analysis services, ssas

964

If a stored procedure is taking a table data type, how it looks?

6372

What will be the maximum number of indexes per table?

925

Explain can SSRS reports Cache results?

154

What are the export options of ssrs?

169