Re: Selecting values from database

2013-07-24 Thread Christian Erhardt
Just do be clear... you are mixing strings and numbers in one table on different rows? I think your data structure is wrong and you will not be able to achieve what you're trying. I'd would be easy if the table would look like this: +-+ |Activities | +-+---+ |A

Selecting values from database

2013-07-23 Thread Sandeep kaur
Suppose I have following table in my database : activity1 | activity2 | activity3 | activity4 | activity5 6| 7 | 5| 9 | 8 The first row are the field names and the second row are the data entries. How can I get 3 maximum values out of each row of this t