Advertiser Disclosure

Download our iPhone app

TODAY'S HEADLINES | ARTICLE ARCHIVE | FORUMS | TIP BANK

Specialized Dev Zones

Research Center

eBook Library

.NET

Java

C++

Web Dev

Architecture

Database

Security

Open Source

Enterprise

Mobile

Special Reports

10-Minute Solutions

DevXtra Blogs

Slideshow

How to Call a Stored Procedure via the JdbcTemplate

How to Increment Integers

Determine if String str2 is a Rotation of String str1

Convert a Given Code Point to a String

Understanding java.net.PasswordAuthentication

Tip: Generating Random Numbers in SQL

Learn how to easily generate a random number.

by Hannes Du Preez

Dec 4, 2018

You can generate a Random number in SQL with the following command:

SELECT RAND() Random_Number

This returns the following value

0.713666525097956

Visit the DevX Tip Bank

Thanks for your registration, follow us on our social networks to keep up-to-date