Select records in Random Order in SQL Server Query

nedash

SOLVED CLOSED ACTIVE ANSWERED
User: nedash
Posted: on Mar 07, 2014 09:26 AM
Forum: SQL Server
Answer: 1
Views: 2169

I have Behcode Table in database

Id	Behcode	Reserved	date
1	1111	NO	2013/5/2
2	1112	Yes	2013/8/2
3	1113	NO	2013/8/4
4	1114	NO	2013/8/8
5	1115	Yes	2013/7/5
6	1116	NO	2013/9/9
7	1117	NO	2013/10/1

and I have Selectbtn Button in my page I want when I click on button in datalist it shows 2 data from Behcode Column in random that reserved column be "NO"

i.e

here these behcode's reserved column are "NO" 1111-1113-1114-1116-1117

Now I want when I click on button it shows 2 behcode in datalist randomly between above behcode that reserved column is "NO"

How I can do it?

Best regards

Neda

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Mar 07, 2014 09:26 AM
Report

Refer:

How to display random records in SQL Server Select Query

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Select records in Random Order in SQL Server Query

Company

Explore

Follow us

Contact Us