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

How to concatenate two strings in SQL Server.

0 Answers   HCL,

How to find the date and time of last updated table?

3 Answers  

Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  

What is data source in connection string?

0 Answers  

What is collation?

0 Answers  

What have included columns when we talk about sql server indexing?

0 Answers  

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

can you any body tell me the how to decrease the logfile

4 Answers  

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

Explain what is log shipping?

0 Answers  

How to modify an existing stored procedure in ms sql server?

0 Answers  

explain different types of jions with examples briefly?

1 Answers   Zensar,

For more SQL Server Interview Questions Click Here
Categories