Share via

select top results without selecting columns

Jonathan Brotto 420 Reputation points
2024-06-04T15:25:35.46+00:00

select top results without selecting columns?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,692 questions
0 comments
Accepted answer
  1. Olaf Helper 46,281 Reputation points
    2024-06-04T17:44:34.7866667+00:00

    What's the problem with?

    SELECT TOP (100) * FROM dbo.YourTable

    Without a ORDER BY clause on an explicit named column you will get a more random result.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.