Answer / priestly george varghese

Select Count(*) as Bike_Count, Owmer from <TN> where Bike
in('pulsar','Honda')
group by Owmer having count(*)>1

Answer / anil

select ownername,count(bike) noofbikes from abikes group by ownername having Count(bike)>1

Answer / valibasha

Select owner from table where bike in(‘pulsar’,’Honda’) group by owner having count(*)>=1

Answer / gaurav.verma4210

select count(*) as no_of_vehical,owner from MulBike group by owner having count(*)>=1

Answer / lakshmi narayanan r

CREATE TABLE bikes (bikeID INT, CName VARCHAR(50), BNAME
VARCHAR(50))

INSERT INTO bikes(CName, BNAME) VALUES ('shanker', 'pulsar')
INSERT INTO bikes(CName, BNAME) VALUES ('shanker', 'Honda')
INSERT INTO bikes(CName, BNAME) VALUES ('shanker', 'car')
INSERT INTO bikes(CName, BNAME) VALUES ('Balu', 'pulsar')
INSERT INTO bikes(CName, BNAME) VALUES ('Balu', 'Honda')
INSERT INTO bikes(CName, BNAME) VALUES ('Balu', 'car')
INSERT INTO bikes(CName, BNAME) VALUES ('Shyam', 'pulsar')
INSERT INTO bikes(CName, BNAME) VALUES ('Jaya', 'Honda')
INSERT INTO bikes(CName, BNAME) VALUES ('Deepa', 'car')
INSERT INTO bikes(CName, BNAME) VALUES ('vasu', 'car')


;WITH tmp (RowId, CName) AS (SELECT ROW_NUMBER() OVER
(PARTITION BY CName ORDER BY BikeID ASC) AS RowId, CName
FROM Bikes)
SELECT DISTINCT CName FROM tmp WHERE RowId > 1

Answer / anand

hey thanks a lot, it is working but with slight modification


Select Count(*) as No-Vehicles, owner from table where
group by owner having count(*)>=1

Regards,
Anand

Answer / gangadharrao

select Owner from dbo.[table] where Bike in (select bike
from dbo.[table]) group by owner having count(*) >1

Answer / vidhya

select count(*) as no_of_vehical,owner_name from vehicles group by owner_name having count(*)>=1

Answer / aditya

select name
from ( select name from bikehaving
where drive in ('pulsur',Homda')) xxx
group by name
having name > 1

Answer / rajkumar v

select Owner, COUNT(*) as Total from table_name group by
Owner having COUNT(*)>1

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

0 Answers   MCN Solutions,

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  

Can a table be created inside a trigger?

0 Answers  

Tell me what is the difference between locking and multi-versioning?

0 Answers  

Do you know how to send email from database?

0 Answers  

Can another user execute your local temporary stored procedures?

0 Answers  

Is null in sql server?

0 Answers  

how to do partition in sqlserver

0 Answers   TCS,

Explain the different types of joins?

0 Answers  

Which sql server table is used to hold the stored procedure script?

0 Answers  

How many categories of functions based their return modes?

0 Answers