〖Orz〗求一条sql语句
〖Orz〗求1条sql语句
想优先 Rand() 出来 'phome_ecms_news' 表的 classid limit 1 (并且符合) isLast(终极栏目) = 1
然后再在 表 'phome_enewsClass' 里面进行 RAND() limit 1
下面sql语句错误..不会写的情况下,只有表述一下思想了.
- SQL code
<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->SELECT * FROM 'phome_ecms_news' WHERE classid = (SELECT classid FROM 'phome_enewsClass' where islast=1 RAND() limit 1) RAND() limit 1;
------解决方案--------------------
- SQL code
SELECT * FROM 'phome_ecms_news' WHERE classid IN ( SELECT classid FROM 'phome_enewsClass' where islast=1 ORDER BY RAND() limit 1 ) ORDER BY RAND() limit 1;<div class="clear">
</div>
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to solve 'undefined: rand.Seed' error in golang?
Jun 25, 2023 am 08:34 AM
During the development or learning process of using Golang, we may encounter the error message of undefined:rand.Seed. This error usually occurs when you need to use a random number generator, because in Golang you need to set a random number seed before you can use the function in the rand package. This article will explain how to resolve this error. 1. Introduce the math/rand package. First, we need to introduce the math/rand package into the code. exist
Detailed explanation of how to use take and limit in Laravel
Mar 10, 2024 pm 05:51 PM
"Detailed explanation of how to use take and limit in Laravel" In Laravel, take and limit are two commonly used methods, used to limit the number of records returned in database queries. Although their functions are similar, there are some subtle differences in specific usage scenarios. This article will analyze the usage of these two methods in detail and provide specific code examples. 1. Take method In Laravel, the take method is used to limit the number of records returned, usually combined with the orderBy method.
How to synchronize random number generation in Golang parallel processing?
Jun 03, 2024 pm 02:53 PM
Synchronizing random number generation in Go concurrent programming: Use a mutex (sync.Mutex) to control access to the rand.Rand random number generator. Each goroutine acquires the mutex lock before generating random numbers and releases the mutex lock after generating it. This ensures that only one goroutine can access the random number generator at a time, eliminating data races.
How to solve the problem of generating the same random numbers using php rand function
Mar 23, 2023 am 09:17 AM
The rand() function uses the same initial seeds on each call. The default initial seed is obtained from the operating system's time, but it only has microsecond accuracy. That is, within a very short period of time, many rand() function calls will use the same initial seed, resulting in the same random number generation. So, how to solve this problem?
Comparison of functions and usage of take and limit in Laravel
Mar 09, 2024 pm 09:09 PM
Take and limit are two commonly used methods in Laravel to limit the number of query result sets. Although they have certain similarities in functionality, they differ in usage and some details. This article will conduct a detailed comparison of the functions and usage of the two methods, and provide specific code examples to help readers better understand the differences between them and how to apply them correctly. 1.take method The take method is in the LaravelEloquent query builder
How to use the limit and skip functions of Stream in Java for stream operations
Jun 26, 2023 pm 03:55 PM
StreamAPI was introduced in Java 8, which can greatly simplify the operation of collections. The Stream class provides many functional methods for operating on streams, including filtering, mapping, merging, and more. Among them, limit and skip are two functions used to limit the number of elements in stream operations. 1. Limit function The limit function is used to limit the number of elements in the stream. It accepts a long type parameter n, which represents the number of limits. After calling the limit function, a new stream is returned, which only contains
A deep dive into the differences between take and limit in Laravel
Mar 10, 2024 pm 01:00 PM
In Laravel, we often use some methods to limit the number of query results, including take and limit methods. While they can both be used to limit the number of query results, they do have some subtle differences. In this article, we'll take a deep dive into how take and limit differ in Laravel, illustrating them with concrete code examples. First, let's look at the take method. The take method is part of Eloquent and is typically used for
How to save Final Fantasy 7 limit
Mar 07, 2024 pm 06:40 PM
When playing in Final Fantasy 7, players can accumulate limits to use extreme skills, which can cause huge damage or provide powerful support effects. Players can obtain limits by receiving damage, attacking enemies, and being hit in combos. How to save the limit in Final Fantasy 7 1. Taking damage When the character is attacked by the enemy or a teammate is attacked, the limit bar will gradually increase. The more damage you take, the faster the limit bar fills. 2. Attacking enemies and actively attacking enemies can also increase the filling speed of the limit bar. Limit can be accumulated using normal attacks, skills or magic. 3. When the hit combo character is attacked by enemies continuously, the filling speed of the limit bar will be accelerated. This can be done by attracting the enemy's attention or by using hold
