how to select distinct records from a database table

[Former Member]

Hi to all,

How to select distinct records from a database table it self.

suppose if it is report level then we can go for select distinct statement.but i don't have authorization for se38.

then how to select distinct records from se11 or se16,

is there any procedure for doing this.

regards,

swami

[former_member156446]

se11>table name > table contents..

edit>download > radio button spread sheet.... export all the entires to excel....

In excel select the colum where you need to distinct values... copy and Advanced paste.. distinct values... done..

Award points if helpful.

[Former Member]

>

> se11>table name > table contents..

>

> edit>download > radio button spread sheet.... export all the entires to excel....

>

> In excel select the colum where you need to distinct values... copy and Advanced paste.. distinct values... done..

> Award points if helpful.

Hi,

but i didbn't found those options at se11.

is there any alternate method for that.

regards,

swami

[Former Member]

Dear Swaminath,

In the screen which displays table entries, click on the icons in the tool bar to export to excel sheet or use the keyborad shortcut CTRLSHFTF7 or CTRLSHFTF9. Before exporting, You can also sort the table entries, by selecting the column for which you want distinct entries and clicking on the 'Sort in Ascending Order' icon (CTRL+F4)

Reward points if useful.

Regards

Vidhya.

[danielschindler_com]

Hi there,

you can use the following programm which is described here:

Best regards,

Daniel