18 Kicks

Selecting Random Records With SQL(carlj.ca)

submitted by CarlJCarlJ(875) 4 years, 5 months ago

Have you ever wanted to be able to SELECT a random record or records from a database table, but was unsure how to do it with SQL, instead of through code? Fortunately there is a way to do it in SQL Server (and MySQL, PostgreSQL, Oracle, DB2, SQLite, and yes, even your favourite, MS Access), and I’ll show you how.

1 comment |category: |Views: 210

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
PHaldonPHaldon(130) - marshallmarshall(0) - Ashhka1Ashhka1(0) - kazimanzurrashidkazimanzurrashid(3965)
More who kicked this story...
Comments:

posted by gt1329agt1329a(7849) 4 years, 5 months ago 0

Handy.

Reply

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?