在SQL中查找合并的数值。

huangapple go评论100阅读模式
英文:

FIind the combined values in sql

问题

  1. 1 VZG IDLI
  2. 2 HYD BIR
  3. 3 AKP NULL
  4. 4 NULL MILK
英文:

I have a table

  1. CREATE TABLE T1 (
  2. ID INT,
  3. PLACE VARCHAR(255),
  4. FOOD VARCHAR(100)
  5. );
  6. INSERT INTO T1 VALUES
  7. (1,'VZG',NULL),
  8. (1,NULL,'IDLI'),
  9. (2,'HYD',NULL),
  10. (2,NULL,'BIR'),
  11. (3,'AKP',NULL),
  12. (4,NULL,'MILK');
  13. SELECT * FROM T1;

======================================

#I Need output TABLE to be

  1. 1 VZG IDLI
  2. 2 HYD BIR
  3. 3 AKP NULL
  4. 4 NULL MILK

============================

I am unable to get the query.

答案1

得分: 2

你可以从这些数值中取得最大值。

select t.id, max(t.place), max(t.food)
from T1 t
group by t.id

请参见dbfiddle

英文:

You can take the max from the values. .

  1. select t.id, max(t.place), max(t.food)
  2. from T1 t
  3. group by t.id

See dbfiddle.

huangapple
  • 本文由 发表于 2023年7月6日 15:06:32
  • 转载请务必保留本文链接:https://go.coder-hub.com/76626270.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定