Click here to Skip to main content
11,717,509 members (81,817 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
What is the meaning of "select 1 as count from tablename" in sql server?
Posted 4-Mar-13 1:27am
Comments
Vardhan Desai at 4-Mar-13 7:45am
   
Downvote. . . It will display that only, I think you you try, rather blindly voting the solutions.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Seems useless, unless you want to get a recordset that consists of '1's with number of records in recordset equal to number of rows in tablename.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

It will Display 1 as a Value and Column name as COUNT, as shown below.

COUNT
----------
1
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

This will just return 1 for no.of column which is available in table as output and column name as Count
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 719
1 OriginalGriff 215
2 F-ES Sitecore 210
3 Maciej Los 140
4 Jochen Arndt 120
0 Sergey Alexandrovich Kryukov 1,494
1 OriginalGriff 535
2 Maciej Los 529
3 Richard MacCutchan 440
4 CHill60 415


Advertise | Privacy | Mobile
Web03 | 2.8.150901.1 | Last Updated 4 Mar 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100