简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home> Database> Mysql Tutorial> body text

mysql-求助一条SQL语句及原理，具体请看描述！

WBOY
Release： 2016-06-06 09:33:28
Original
1195 people have browsed it

mysqlsql

图片说明
如图所示订单表 pid 为null的是主订单
需求是 按主订单ddate倒序排列，子订单排在主订单后面
最终结果如图：
图片说明
我写的SQL语句可以实现

 SELECT DISTINCT id from ( SELECT b.id, a.ddate FROM `tttest` a , `tttest` b where a.id = b.pid union SELECT c.id,c.ddate from tttest c ) t ORDER BY t.ddate desc ,id
Copy after login

但是太复杂 求一条简介的SQL

Related labels：
mysql sql
source：php.cn
Previous article：mysql 触发器插入数据可以，但是update没有成功，update前后的insert都执行了 Next article：mysql-MySQL 无法撤销主键约束
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Write sql statements using tp5 framework How to write the following sql statement using tp? select * from `student` where sex = 1 a...
From 2021-09-03 10:30:52
0
3
848
spring - Regarding the problems encountered in keyword query: the problem of writing sql statements into java I am a database novice. My senior assigned me a keyword query task. I encountered some pro...
From 2017-05-27 17:41:38
0
2
585
PHP compound query statement? SELECT COUNT(*) AS num FROM lzh_cds c LEFT JOIN lzh_rds r ON c.rd_id=r.rd_id LEFT JOIN lzh...
From 2017-05-16 13:14:40
0
1
512
node.js - nodejs的根数据库连接的后端开源框架市面上有吗？ 想做一个dao层把curd各语句和各种查询条件抽出来要包含() or and like in notin 跨表查询 orderly group 甚至union不知道市面上有没有这种...
From 2017-04-17 16:02:18
0
1
298
mysql查询id,IN根据结果模糊问题 select id,title,content from myarticle where id IN(219,220,222,225) and content like '明明' ...
From 2017-04-17 13:47:58
0
2
476
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！