SQL to Select a random row from a database table

CK CK 3788 
Created at  
542 0 0

There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax.

Select a random row with MySQL:

SELECT column FROM table
ORDER BY RAND()
LIMIT 1


Select a random row with PostgreSQL:

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1


Select a random row with Microsoft SQL Server:

SELECT TOP 1 column FROM  table
ORDER BY NEWID()

 

Select a random row with IBM DB2

SELECT column, RAND() as IDX 
FROM table 
ORDER BY IDX FETCH FIRST 1 ROWS ONLY

Thanks Tim

 

Select a random record with Oracle:

SELECT column FROM
( SELECT column FROM table
ORDER BY dbms_random.value )
WHERE rownum = 1

Thanks Mark Murphy

Tags SQL image upload by metaweblog API metaWeblog API file attachment select rndom row Facebook X
Comments 0
Similar posts
  1. Setting TQuery SQL Statement
    12,164
  2. How to optimize MySQL automatically in CentOS Linux
    1,010
  3. mysql optimization – if you are using Word Press, do not turn off persistent connection
    596
  4. How to download/grap web pages or XML document at internet website in Delphi XE?
    880
  5. The Ultimate Data Engineering Roadmap
    1,082
  1. FNC(Photo/Video File Name Changer) v1.1 Release - Date Time Bug Fix & Retry Function Added
    708
  2. Smart TV Cycling Apps – TV for Fitness
    813
  3. The public could reduce server cost, and enhance performance for global service distribution
    10,744
  4. Cloud gaming coming to Samsung Smart TVs
    560
  5. Kids App – Kids Learn While Parents Control on Samsung Smart TV
    764
  6. Fitness Hub presents your personal trainer, Fitness VOD on Samsung Smart TV
    521
  7. Word counting source program based on MapReduce framework
    692
  8. The leaders who created Smart TV
    818
  9. FNC(Photo/Video File Name Changer) v1.02 release - The file created date time information is available for those cameras providing incorrect EXIF data
    977
  10. Samsung Apps hits 5 million Smart TV app downloads
    650
  11. Your Video – VoD content recommendation service on Samsung Smart TV
    561
  12. Amazon S3 File Explorer : You can use S3 like Windows File Explorer
    565
  13. FNC(Photo/Video File Name Changer) v1.01 release
    770
  14. FNC(Photo/Video File Name Changer) v1.0 release
    786
  15. How to search file on certain directory ?
    633
  16. DataPlay – Change the world with brand new media
    685
  17. Content Manager for The world’s first MP3 Phone
    601
  18. yepp Explorer – File Management Application for MP3 Device
    655
  19. MusicDrive – DRM enabled Secure Music Player on Microsoft Windows
    909
Recently updated
  1. Google OAuth Token Expiration: Causes and Solutions
    29
  2. Why 100% SEO Guarantees Better User Engagement and How to Achieve It in Your Service
    55
  3. Why SPF and DKIM Are Essential for Linux Email Servers?
    49
  4. How do I create animated background for Google Meet?
    22,895
  5. MaxMind GeoLite2 vs. DB-IP Lite vs. ip-api.com: Choosing the Right Free IP Geolocation Solution
    271
  6. Meet Valkey: Why Redis Changed Its License, Why Valkey is Better, and How to Use It as a Drop-in Replacement
    103
  7. How Rogue Web Scrapers Are Stealing My Content and Destroying My Server
    168
  8. Array of arguments passed to script in PHP
    97
  9. Invalid Auction Storms in Ad Tech
    106
  10. Building MRC-Compliant Instrumentation in Ad Tech: Implementation Steps and Key Challenges
    207
  11. The Two Clocks of Ad Server Architecture
    77
  12. Frequency Cap Architecture Overview
    526
  13. Collecting Proof-of-Play from 100,000 Screens
    152
  14. Vector Search in Relational Databases (RDBs): Trends & Usage Environments
    302
  15. What is RedisVL?
    114
  16. Designing a Skill Registry Architecture: Minimize Token Usage and Maximize AI Performance
    246
  17. TPU & GPU Cluster Management Tools
    257
  18. The Concept of Scaffolding in AI Agents
    244
  19. Beyond Static Pipelines: Architecting LLM Multi-Agent Systems for Autonomous Workflow Orchestration
    596
  20. AI-DLC vs. AI-SDLC: Model-Centric vs. System-Centric AI Development
    267
  21. Fine-Tuning Open-Weight LLMs: Training, Licensing, and Deploying Custom Models with Ollama
    353
  22. Inside the Next-Generation Streaming Architecture: Ultra-Low Latency, SGAI, and AI Codecs
    206
  23. Machine Learning: Training vs. Ranking
    229
  24. The Continuous Learning Machine: Designing a Loop That Actually Turns
    228
  25. The Next-Gen Low-Latency Standards: LL-HLS & MoQ
    202
  26. Designing a Data Curation System Around a Vector Database
    230
  27. Extracting Context from Live Video: The Architecture Got Simpler When We Stopped Building Features
    263
  28. The New Ad Stack Behind Live Sports Streaming: Inside SGAI, EABN, and the Standards Race to Fix Live Monetization
    671
  29. Designing MLOps Architectures to Handle Seasonal Data Drift in EV Fleet Models
    200
  30. From 15 to 40+ FPS: Accelerating PyTorch Object Detection on Automotive ECUs
    232