SQL查询选择数据 [英] sql query for select data

问题描述

我有一个tbl_album表.
列名称为id，album_name和image_name.
我想选择所有具有一个图像名称的专辑.

I have a tbl_album table.
The columns names are id, album_name and image_name.
I want to select all albums with one image name.

推荐答案

select distinct album_name where image_name LIKE '%what you want to compare%'

是吗 ? :confused:

Is it ? :confused:

您好，

那一个呢:

Hello,

what about this one:

select album_name 
from tbl_album 
group by album_name 
having count(image_name ) = 1

瓦莱里.

Valery.

这篇关于SQL查询选择数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！