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

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

What is the difference between ExecuteScalar, ExecuteReader and ExecuteNonQuery?

 ExecuteScalar is typically used when your query returns a single value. If it returns more, then the result is the first column of the first row. An example might be SELECT @@IDENTITY AS 'Identity'.  ExecuteReader is used for any result set with multiple rows/columns (e.g., SELECT col1, col2 from sometable).  ExecuteNonQuery is typically used for SQL statements without results (e.g., UPDATE, INSERT, etc.).
Post a Comment
Read more