Try to search your question here, if you can't find : Ask Any Question Now ?

SQL select only one row (with all attibute values) of each different value

HomeCategory: stackoverflowSQL select only one row (with all attibute values) of each different value
Avatarcraig asked 4 months ago

in SQL Developer, i want to select only one row from my table (with all attibute values) of each different value.
It’s not important what row is selected for each type, what matters is to select only one row for type.

for example i have this table:

| A |  B  | C |
  X    SS   G
  Y    SB   T
  Z    SB   T

Note that in my table there aren’t numbers.

The result i want is:

| A |  B  | C |
  X    SS   G
  Z    SB   T

But is correct also

| A |  B  | C |
  X    SS   G
  Y    SB   T

Thank you!

1 Answers
Best Answer
AvatarMikhail answered 4 months ago
Your Answer

16 + 15 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com