.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

select COUNT(column_name) from table_name counts only

Posted By :Syed Shakeer Hussain     Posted Date :November 29, 2009    Points :10   Category :Sql Server 
NON NULL Columns

You can also find related Interview Question to select COUNT(column_name) from table_name counts only  below: 

How to get the column count of a report?

  
SY-LINSZ system variable gives the column count (line size) and SY-LINCT for line count. (More...)

Select Syntax

  
SELECT "COLUMN_NAME" FROM "TABLE_NAME" (More...)

What is COUNT Syntax?

  
SELECT COUNT("EMPLOYEE_NAME") FROM "EMPLOYEE_TABLE";
or
SELECT COUNT(*) FROM "EMPLOYEE_TABLE";


COUNT is arithmetic function, This is return number of row. (More...)

COUNT and DISTINCT Syntax?

  
SELECT COUNT(DISTINCT EMPLOYEE_NAME) FROM EMPLOYEE_TABLE;

Fetch the number of distinct entries in a Employee_table. (More...)

Write and justify output of - select nullif('test','test')

  
The output will be - NULL
Justification : nullif returns NULl if given two arguments are same else returns the first specified argument. So, for the given SQL, output will be NULL. (More...)

What is the error in the following command?
DROP TABLE &TABLE_NAME;

  
Variable names should start with an alphabet. Here the table name starts with an '&' symbol. So it will give a compilation error. (More...)

Difference between Set and Select keyword in sql server?

  
Set:

1.Set is a ANSI standard for variable assignment.
2.We can assign only one variable at a time
3.When assigning from a query that returns more than one value, SET will fail with an error.

Select:

1.Select is a Non-ANSI standard when assigning variables.
2.We can assign multiple variable at a time
3.When assigning from a query that returns more than one value, SELECT will assign the last value returned by the query and hide the fact that the query returned (More...)

How to Select a value from Dataset?

  
By Using DataTable.Selet() Method? (More...)

Write a query to Select top 2 Highest salaries?

  
select Top(2) salary from Tablename order by Salary desc.... (More...)

Consider the following code:

public class Example extends Thread
{
public void run()
{
System.out.println ("Hello");
}

public static void main (String args[])
{
new Example();
}
}

Select the correct option regarding the preceding code ?

  
1, The code will not compile.
2, The code will compile but will not execute.
3, The code will compile, execute, and display Hello as the output.
4, The code will compile, execute, but will not display anything.

Answer : 4 (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend