select top results without selecting columns

Jonathan Brotto 180 Reputation points

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.
13,117 questions
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,583 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 42,576 Reputation points

    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 No comments

0 additional answers

Sort by: Most helpful