Click here to Skip to main content
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 2: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 OriginalGriff 5,130
1 DamithSL 4,237
2 Maciej Los 3,700
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,846


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 4 Mar 2013
Copyright © CodeProject, 1999-2014
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