Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Sql query problem

2 Posts 2 Posters 0 Views 1 Watching

A Offline
A Offline
adkalavadia

wrote on last edited by

#1

id person bar 1 ankur royal 2 ankur wishy 3 punit royal 4 punit wishy 5 ankit royal result will be Ankur punit i want to list person who use more than one bar.how can i do...i want sql query for ms access. thank in advance...

!- F - R - I - E - N - D - S -!
I 1 Reply Last reply

0
A adkalavadia

id person bar 1 ankur royal 2 ankur wishy 3 punit royal 4 punit wishy 5 ankit royal result will be Ankur punit i want to list person who use more than one bar.how can i do...i want sql query for ms access. thank in advance...

!- F - R - I - E - N - D - S -!
I Offline
I Offline
i j russell

wrote on last edited by

#2

SELECT person FROM [tablename] GROUP BY Person HAVING COUNT(bar) > 1
1 Reply Last reply

0

Log in to reply