Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
dmohanty
Partner - Specialist
Partner - Specialist

SQL Requirement


Hi All,

Could some one help me with a requirement like this ?

Suppose my query is like this, which hits the database:

SELECT * from Schema.TableName;

Result (Alphabetically):

A

ALL

B

BALL

C

CAT

D

DOLL

E

EGG

Now my requirement is to get the reult in which 'ALL' should be at first, then rest of the values Alphabetically. Quite interesting gonna be. Please guide.

1 Reply
antose
Partner - Creator II
Partner - Creator II

Hi!

Try this!

Skärmklipp1.PNG.png

Skärmklipp2.PNG.png