Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

i want only duplicates rows from coloumn
ex. emp_id(colomn name)1,1,2,3,3,4,5,5.

so i want only duplicates no.

Question Posted / ravindra nhavi

Answers were Sorted based on User's Feedback



i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only ..

Answer / kumar.t

Select Emp_Id, Count(Emp_Id) From Employee As Emp
Group By Emp_Id
Having Count(Emp_Id)>1


By
Kumar

Is This Answer Correct ?    17 Yes 2 No

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only ..

Answer / chinna_g

You have 'emp' table with empid,empname,empsal.
With values:
1 row:1,'hhh',10000
2 row:2,'nnn',10000
3 row:3,'vvv',15000
4 row:4,'jjj',10000

A)
In this table you have sal column 10000 repeating 3 times
in the table, if you want to retrieve the repeated values
i.e. the salary column with 3 times to be displayed in the
following query:

"select empsal from emp where empsal in(select empsal from
emp group by empsal having count(empsal)>1);"

Is This Answer Correct ?    9 Yes 1 No

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only ..

Answer / v rajkumar

select Emp_Id from Employee group by Emp_Id having count(*)
>1

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

0 Answers  

What is blocking?

0 Answers  

What are dml (data manipulation language) statements in ms sql server?

0 Answers  

Why would you call update statistics?

0 Answers  

What according to you is the difference between mysql and sql server performance?

0 Answers  

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

Explain filtered indexes benefits?

0 Answers  

how to rename the table

3 Answers  

Tell me what are cursors and when they are useful?

0 Answers  

What is a subquery in a select query statement in ms sql server?

0 Answers  

How can you append an identity column to a temporary table?

0 Answers  

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories