Export unique host names

marta11 posted 12 months ago in Import/Export

Hi there,

i have a problem. I got very big database and i want to export only unique host names. For example:

Host

Windows key, Facebook key, Image key, Windows key

And i want to make it look like that:

Windows key, Facebook key, Image key,

With no multiply names. I know that unique command can be written to query section. Maybe someone can help me there?

ansgar posted 12 months ago
SELECT DISTINCT yourkey FROM yourtable
marta11 posted 12 months ago

Entered : select distinct "cd-key" from mytable

and it found only one record with "cd-key"

What i need is all "app" which is named "CD-KEY" with no multiple or doubled hosts.

ansgar posted 12 months ago

You need to select a column name, not a value in that column. So, if your key column is named "k", then do a SELECT DISTINCT k .... Something in double quotes is considered as string literal, not as a column identifier, and so your SELECT "cd-key or something" always works with one result.

marta11 posted 12 months ago

Thank you for your patient.

So if i want to find all unique CD-KEY's from "Windows 7 Ultimate" host, what should i put in query tab?

Adding screenshot prnt.sc/fgankg

ansgar posted 12 months ago

Well, your column seems to be named "login", so it's SELECT DISTINCT login FROM...

marta11 posted 11 months ago

Thing is that database exports all unique "login"'s. I need only Windows 7 Ultimate.

Please login to leave a reply, or register at first.