Angela4eva
asked on
sql query
I have a table field field called zones
Zones has values like
D4.6.D7
D5.Time
Time.D4
5.D4
D8.D4.D8.9
D8.Time.D6
D5.D5.D5
D4
I want to write a query to have only two values lowest and the greatest
D4--lowest
4
D5
5
D6
6
D7
7
D8
8
D9
9
D10
10--highest
]if there is item called time then it should be the only thing in it.All the other option should be removed.
So the result for above data should be
D4.D7
Time
D4.5
D4.9
Time
D5.D5
D4.D4
Zones has values like
D4.6.D7
D5.Time
Time.D4
5.D4
D8.D4.D8.9
D8.Time.D6
D5.D5.D5
D4
I want to write a query to have only two values lowest and the greatest
D4--lowest
4
D5
5
D6
6
D7
7
D8
8
D9
9
D10
10--highest
]if there is item called time then it should be the only thing in it.All the other option should be removed.
So the result for above data should be
D4.D7
Time
D4.5
D4.9
Time
D5.D5
D4.D4
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Not really sure what you're asking. Can you provide an explanation as to how you arrive at those results?