How to get random rows from SQL Server Table – TSQL Tutorial Part 117

June 25, 2020



SQL Server / T-SQL Tutorial Scenario:
How to get random rows from SQL Server Table

Scenario:
You are working as SQL Server developer. You are asked to provide sample random data from dbo.Customer table. You might asked to provide random 100 rows or some percent of total data from table. What query you will use to provide required output?

Solution:
In previous post, we learnt how to get top n rows from table. We can either provide row count or percent of records we want to get from a table by using TOP in our select query.

We can use the same Top clause but as we are asked to provide the random records, we need to sort them randomly first. We can use newid() function in order by clause to sort them randomly.

Link to scripts used in SQL Server / TSQL Tutorial Video

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)

Nguồn: https://mensagensdamanha.com/

Xem thêm bài viết khác: https://mensagensdamanha.com/cong-nghe/

All Comments

  • tks so much. great tutorial

    4FreeUnlimited June 25, 2020 10:32 pm Reply
  • for the video in first place. Now, what if I wanted a sample row with a condition such as "2 samples from 'US', and one from 'CA'… Thanks in advance.

    prashant wardhan June 25, 2020 10:32 pm Reply
  • Its not working oracle

    Mohd Irfan June 25, 2020 10:32 pm Reply
  • Can you tell me
    how can do the same in oracle 11g ?

    Mohd Irfan June 25, 2020 10:32 pm Reply
  • its seem to be useful

    Mohd Irfan June 25, 2020 10:32 pm Reply
  • Thank You !!

    Sannareddy Harshavardhan June 25, 2020 10:32 pm Reply

Leave a Reply

Your email address will not be published. Required fields are marked *