Skip to main content

How to Get a Random Row From a SQL Database?

How to Get a Random Row From a SQL Database?

use this Quary
  • select Top 5 Id from YourTable order by NEWID()  

NEWID (Transact-SQL) 

Applies to: SQL Server (SQL Server 2008 through current version).
Creates a unique value of type uniqueidentifier.

NEWID() is based on a combination of a pseudorandom number (from the clock) and the MAC address of the primary NIC.

However, inserting random numbers like this as the clustered key on a table is terrible for performance. You should consider either NEWSEQUENTIALID() or a COMB-type function for generating GUIDs that still offer the collision-avoidance benefits of NEWID() while still maintaining acceptable INSERT performance.

Comments

Post a Comment

Popular posts from this blog

How to get First,Last,Next,Previews Data in .Net C#

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.Odbc; using System.IO; namespace WindowsApplication1 {     public partial class Form1 : Form     {         public Form1()         {             InitializeComponent();         }         OdbcDataAdapter da;         DataSet ds;         int i = 0;         int j;         OdbcConnection conn;         int last;         private ...
54 comments
Read more

MIME Types list

Multipurpose Internet Mail Extensions (MIME) is an Internet standard that extends the format of email to support: Text in character sets other than ASCII Non-text attachments: audio, video, images, application programs etc. Message bodies with multiple parts Header information in non-ASCII character sets    MIME Types list   Suffixes Mime .3dm x-world/x-3dmf .3dmf x-world/x-3dmf .a application/octet-stream .aab application/x-authorware-bin .aam application/x-authorware-map .aas application/x-authorware-seg .abc text/vnd.abc .acgi text/html .afl video/animaflex .ai application/postscript .aif audio/aiff .aif audio/x-aiff .aifc audio/aiff .aifc audio/x-aiff .aiff audio/aiff .aiff audio/x-aiff .aim application/x-aim .aip text/x-audiosoft-intra .ani application/x-navi-animation .aos application/x-nokia-9000-communicator-add-on-software .aps application/mime .arc ap...
4 comments
Read more