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

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

Question Posted / aditya

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain relational data?

931

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

954

What is the difference between left and right outer join?

1075

What do you understand by SQL*Net?

1040

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1090

How to disable stored procedure sql server?

1612

What is the difference between lock, block and deadlock? : sql server database administration

1057

what's the difference between a primary key and a unique key? : Sql server database administration

960

What is in place upgrade in sql server?

1053

What command is used to rename the database?

1021

Distinguish between commit and rollback?

968

Why de-normalization required?

1014

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2792

How to convert a table data in XML format in sql server?

2552

What does null mean?

993