SELECT COUNT('7') ?

Posted by Bandi on 6/23/2015 | Category: Sql Server Interview questions | Views: 4159 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Select from following answers:

Throws error
7
0
1
All Above

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

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 ...