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

How to put counter of remaining charector of text in textbox

How to put counter for char remaining in textbox Html <asp:TextBox runat="server" ID="TxtBody" CssClass="form-control" TextMode="MultiLine" Rows="5" placeholder="Body" MaxLength="159" ></asp:TextBox> <div id="Textremaining"></div> Javascript $(document).ready(function() {     var maxChar = 159;     $('#Textremaining').html(maxChar + ' remaining');     $('#<%=TxtBody.ClientID%>').keyup(function() {         var length = $('#<%=TxtBody.ClientID%>').val().length;         var remaining = maxChar - length;         $('#Textremaining').html(remaining  + ' characters remaining');     }); });
3 comments
Read more