Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

top 10 of records matching distinct combinations

Status
Not open for further replies.
fredericofonseca

fredericofonseca

IS-IT--Management
Jun 2, 2003
3,324
PT
have a look at thread1662-1609753
although it is on a Oracle database, if it can be done with standard Ansi SQL it will be fine with me.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
Count records until a record value changes
Replies
2
Views
237
carp
carp
sal21
  • Locked
  • Question
SELECT COUNT distinct
Replies
5
Views
171
sal21
sal21
sal21
  • Locked
  • Question
SORT by part of filed 2
Replies
5
Views
168
2009luca
2009luca
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
135
carp
carp
ahadali79
  • Locked
  • Question
Getting a part of string
Replies
2
Views
126
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top