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

What is the sql profiler?

0 Answers  

When would you use it?

0 Answers  

How to define and use table alias names in ms sql server?

0 Answers  

What is a result set object returned by mssql_query()?

0 Answers  

How to drop an existing table with "drop table" statements in ms sql server?

0 Answers  

whats new about truncate in sql server 2008?

0 Answers   MedSave Healthcare, Serco,

What is an active database?

0 Answers   HCL,

What are the differences between decimal and float in ms sql server?

0 Answers  

What is user-defined inline table-valued function?

0 Answers  

Differences between Standby Vs No recovery?

2 Answers   Wipro,

How many non clustered indexes there can be on table ?

0 Answers  

What are the type of Indexes? which one is best, why?

6 Answers