Using DISTINCT and TRIM function on same column in... - SAP Community

Hi,

Can we use DISTINCT and TRIM function on same column in single select.

expl: Select Distinct (TRIM(NAME)) from Table;

this is giving error

SAP Managed Tags:
SAP HANA

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Answers (1)

Hi,

We can definitely use it , can you put the screen shot of the error your getting.

Regards,

Anil

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

Yes we can use distinct and trim in single select

Please find the below attachment

Regards

Khaga

Ask a Question

Top Q&A Solution Author

User

Count

95

11

10

9

9

7

6

5

5

4