PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WEBDEV 2024 → Select Rand() on weddev
Select Rand() on weddev
Started by arsistemas, Feb., 18 2014 1:52 PM - 3 replies
#1
Registered member
11 messages
Posted on February, 18 2014 - 1:52 PM
Hello Everybody, :)

How to create a QRY rand()?

Eg: SELECT * FROM costumer ORDER BY rand() LIMIT 5;

Thanks,

--
AR-Sistemas R/S
Desenvolvimento de sites e aplicativos administrativos
WebDev v18 - Perfeito e Simples | UP 19 Full Solution
#2
Registered member
11 messages
Posted on March, 11 2014 - 1:30 PM
UP

--
AR-Sistemas R/S
Desenvolvimento de sites e aplicativos administrativos
WebDev v18 - Perfeito e Simples | UP 19 Full Solution
#3
Posted on March, 11 2014 - 5:34 PM
Hello,

When you want to use Windev function xxx in SQL, you just have to say WL.xxx in your request.

I suggest you :

select * from
( select c.* , wl.random() as R from customer c )
order by R
limit 5
#4
Registered member
11 messages
Posted on March, 12 2014 - 1:37 PM
Thanks Bernard.

--
AR-Sistemas R/S
Desenvolvimento de sites e aplicativos administrativos
WebDev v18 - Perfeito e Simples | UP 19 Full Solution
→ Go back to WEBDEV 2024