Buy Questpond's video subscriptions on
huge discount
.
Online: 1675
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
SELECT COUNT('7') ?
Posted by
Bandi
on 6/23/2015 | Category:
Sql Server Interview questions
| Views: 4152 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
Throws error
7
0
1
All Above
SELECT Count( anyConstant) will always results to 1
Show Correct Answer
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
SELECT COUNT(*) ?
Next > :
SELECT 'Chandu' + 1 ?
Comments or Responses
Posted by:
Sojanya
on: 6/26/2015 |
Points: 10
Yes, the answer for SELECT COUNT() will be always 1. It can be below three examples.
SELECT COUNT(*)
SELECT COUNT(1)
SELECT COUNT('1')
If we associate any of these with any table then it will return the number of rows from that table.
For example:
SELECT COUNT(*) FROM tblSchool
Login to post response
More Interview Questions by Bandi
SELECT 'Chandu' + 1 ?
SELECT 'Chandu' + ‘1’ ?
what is the output of below SELECT? SELECT (SELECT 'Chandu')
Output of this SQL ? SELECT SELECT 'Chandu'
Output of this query ? SELECT * FROM 'TableA'
Output of below SQL ? SELECT * FROM TableA , TableB
SELECT COUNT(*) + COUNT(*) ?
What is the output of below SQL ? SELECT 'sampleText' FROM ...
Latest Interview Questions
Which property is used to change the left margin of an element?
How do you add a background color for all <h1> elements?
Which is the correct CSS syntax?
What is the full form of CSS ?
How can you insert a search icon?
Which class is used to create a button group?
Which button class is used to create a large button?
The Bootstrap grid system is based on how many columns?
More ...