SELECT TOP 1 * FROM table ORDER BY NEWID()SELECT * FROM table ORDER BY NEWID()
A NEWID() is generated for each row and the table is then sorted by it. The first record is returned (i.e. the record with the "lowest" GUID).
Subscribe to:
Post Comments (Atom)
Using Authorization with Swagger in ASP.NET Core
Create Solution like below LoginModel.cs using System.ComponentModel.DataAnnotations; namespace UsingAuthorizationWithSwagger.Models { ...
-
string[] Files; var root = Application.ExecutablePath; ...
-
Inbox.aspx <%@ Page Title="" Language="C#" MasterPageFile="~/Marketing/admin.master" EnableEventValid... -
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.D...
No comments:
Post a Comment