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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL grouping query

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Could anyone tell me how group parts of a field please?

eg if I had a list of salarys and wanted to group them 10-20k 20-40k and 40k+ how would I do this?

Thanks
 
Sort by date Sort by votes

I replied to your post in the Access forum. Are you seeking an ANSI SQL answer or an Access answer? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
207
carp
carp
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
182
carp
carp
manbob
  • Locked
  • Question
need a help with sub query getting group ereor, please correct
Replies
2
Views
191
carp
carp
jchewsmith
  • Locked
  • Question
SQL Syntax 1
Replies
1
Views
188
JarlH
JarlH
jchewsmith
  • Locked
  • Question
Update Query with a MAX(Date) subquery 1
Replies
1
Views
237
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top