Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12 Answers
- 15347 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
Answer Posted / rajkumar v
select Owner, COUNT(*) as Total from table_name group by
Owner having COUNT(*)>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I save a stored procedure in sql server?
What is difference between rownum and row_number?
Do you know what is user defined datatypes and when you should go for them?
Explain log shipping?
What is primary key and example?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What are different types of data sources?
How many types of triggers in sql server?
What is a sql join?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is ssl in sql server?
How to join two tables in a single query in ms sql server?
How can sql server instances be hidden?
Do you know what is a with(nolock)?
How to handle error or exception in sql?
