Dev Corner

Software Developer’s Notepad

Select Random Row form IBM DB2 Table

baobab under Database

This tutorial shows how to select random row from IBM DB2 table.

SELECT first_name, last_name, RAND() AS IDX 
FROM customer 
ORDER BY IDX FETCH FIRST 1 ROWS ONLY
« Select Random Row in Microsoft SQL Server (MSSQL)
Data Expressions or Backus-Naur Form (BNF) »

Add A Comment

You must be logged in to post a comment.

Subscribe to Dev Corner