Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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