php - mysql，获取最后一个类别中的最后一个文章

Question

我想获取数据库最后带有“IDJurnal”的所有文章这是我的 table

CREATE TABLE `artikel`(
`IDArtikel` INT(11)NOT NULL AUTO_INCREMENT,
`IDJurnal` INT(11)NOT NULL,
`IDKategori` INT(11)NOT NULL,
`judul` VARCHAR(255)NOT NULL,
`abstract` text NOT NULL,
`nama_file` VARCHAR(255)NOT NULL,
`hits` INT(11)NOT NULL,
`didownload` INT(11)NOT NULL,
`created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` VARCHAR(255)NOT NULL,
`updated_time` datetime NOT NULL,
`updated_by` VARCHAR(255)NOT NULL,
PRIMARY KEY(`IDArtikel`))ENGINE = INNODB AUTO_INCREMENT = 12 DEFAULT CHARSET = utf8;

我的jurnal表是

CREATE TABLE `jurnal`(
`IDJurnal` INT(11)NOT NULL AUTO_INCREMENT,
`volume` VARCHAR(255)NOT NULL,
`nomor` VARCHAR(255)NOT NULL,
`bulan` INT(2)NOT NULL,
`tahun` INT(4)NOT NULL,
`halaman` INT(4)NOT NULL,
`issn` VARCHAR(255)NOT NULL,
`pengantar` text NOT NULL,
`redaksi` text NOT NULL,
`cover` VARCHAR(255)NOT NULL,
`created_time` datetime NOT NULL,
`created_by` VARCHAR(255)NOT NULL,
`updated_time` datetime NOT NULL,
`updated_by` VARCHAR(255)NOT NULL,
PRIMARY KEY(`IDJurnal`))ENGINE = INNODB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8;

我的情况如何查询？这是我从 artikel tabel 得到的结果

IDArtikel = 1, IDJurnal=1

IDArtikel = 2, IDJurnal=2IDArtikel = 3, IDJurnal=2

我想要的是，IDArtikel = 2，IDJurnal = 2IDArtikel = 3, IDJurnal=2

IDJurnal 最后一次输入

Answer 1

SELECT * FROM `artikel` WHERE `IDJurnal` = (SELECT `IDJurnal` FROM `jurnal` ORDER BY `IDJurnal` DESC LIMIT 1)

http://sqlfiddle.com/#!2/f1dae/2/0