write a query for list of owner who are having multiple
bikes in below table
1 shanker pulsar
2 shanker Honda
3 shanker car
4 Balu pulsar
5 Balu Honda
6 Balu car
7 Shyam pulsar
8 Jaya Honda
9 Deepa car
10 vasu car
Answers were Sorted based on User's Feedback
Answer / priestly george varghese
Select Count(*) as Bike_Count, Owmer from <TN> where Bike
in('pulsar','Honda')
group by Owmer having count(*)>1
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / anil
select ownername,count(bike) noofbikes from abikes group by ownername having Count(bike)>1
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / valibasha
Select owner from table where bike in(‘pulsar’,’Honda’) group by owner having count(*)>=1
Is This Answer Correct ? | 7 Yes | 5 No |
Answer / gaurav.verma4210
select count(*) as no_of_vehical,owner from MulBike group by owner having count(*)>=1
Is This Answer Correct ? | 1 Yes | 0 No |
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
Is This Answer Correct ? | 1 Yes | 0 No |
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
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / gangadharrao
select Owner from dbo.[table] where Bike in (select bike
from dbo.[table]) group by owner having count(*) >1
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vidhya
select count(*) as no_of_vehical,owner_name from vehicles group by owner_name having count(*)>=1
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / aditya
select name
from ( select name from bikehaving
where drive in ('pulsur',Homda')) xxx
group by name
having name > 1
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rajkumar v
select Owner, COUNT(*) as Total from table_name group by
Owner having COUNT(*)>1
Is This Answer Correct ? | 0 Yes | 0 No |
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is the use of stored procedure?
What are the system database in sql server 2008?
How does normalization work?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How to select all columns of all rows from a table with a select statement in ms sql server?
What are entities and relationships?
Why do we use trigger?
When to use Inner join & when to use subquery?
What is a periodical index?
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.
What is the use of Port no?