How to sort values in columns. [message #378645] |
Wed, 31 December 2008 03:47 |
adnanBIH
Messages: 41 Registered: November 2007 Location: BiH, Sarajevo
|
Member |
|
|
Is there any way to sort the values in columns from the picture?
For example, i have three columns: empno, ename, job, with the values:
empno ename job
1 Jasmin manager
2 Adnan manager
3 Chuck worker
I would like to get this order by the ename parameter:
empno ename job
2 Adnan manager
3 Chuck worker
1 Jasmin manager
Thx in advance.
-
Attachment: sample.JPG
(Size: 15.42KB, Downloaded 511 times)
|
|
|
|
Re: How to sort values in columns. [message #378692 is a reply to message #378658] |
Wed, 31 December 2008 06:49 |
adnanBIH
Messages: 41 Registered: November 2007 Location: BiH, Sarajevo
|
Member |
|
|
Littlefoot wrote on Wed, 31 December 2008 11:27 | Open datablock's Property Palette window; go to its Database node and enter "order by ename" into the "ORDER BY Clause" property.
|
Thx for reply, but I mentioned on how to sort values dynamically (as you could sort columns in Excel, for example).
|
|
|
|