InterviewUp – Job Interview Questions and Answers – What does the count function do in SQL?

January 08, 2009

Home

Sign-In

My Interview Questions

Question & Additional Information

124

UPs

What does the count function do in SQL?

Comments (0) |

Inappropriate

Asked By: Anonymous

Back

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Answer

Edit

The COUNT function tells you how many rows were in the result set.
SELECT COUNT(*)

Tags

Edit

function, SQL, COUNT, SELECT COUNT(*), groupfunction

Asked At

Edit

None

Job Titles

Edit

None

Comments (0) :

Your Name:

Add your comment text

Tags

None

Asked At

None

Job Positions

None

Click here to improve the Interview Question, Answer and other fields.

Comments (1) :

bbfromdc123

Saturday, November 29, 2008 11:53 AM

I know I know I know...

See all 1 comments

UPs

How do you execute a UNIX command in the background?

Add or view comments about this interview question

Comments (0) |

Share this interview question with your friend

Inappropriate

View all interview questions asked by this user

Asked By: thunderd |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

To run the count program, which will display the process identification number of the job, enter: count &

To check the status of your job, enter: ps

To bring a background process to the foreground, enter: fg

If you have more than one job suspended in the background, enter: fg %#

Replace # with the job number, as shown in the first column of the output of the jobs command.

You can kill a background process by entering: kill PID

Replace PID with the process ID of the job. If that fails, enter the following:

kill -KILL PID

To determine a job's PID, enter: jobs -l

If you are using sh, ksh, bash, or zsh, you may prevent background processes from sending error messages to the terminal. Redirect the output to /dev/null using the following syntax: count 2> /dev/null &

Create Date

Sunday, May 11, 2008

Tags

Bluetooth

Asked At

None

Job Positions

Network Administrator

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

151

UPs

when do you use a function pointer as opposed to function call ?

Comments (0) |

Inappropriate

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

you use function ptr when you want to call multiple functions using the ptr in a loop.
like have an array of funtion ptrs, loop through the array and execute the functions.

Create Date

Monday, January 21, 2008

Tags

Asked At

None

Job Positions

None

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

UPs

what is the difference between method and function ?

Comments (0) |

Inappropriate

Asked By: anujtripathi |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Methods are for objects functions are regular routines

Create Date

Thursday, October 16, 2008

Tags

C, include, C++

Asked At

None

Job Positions

None

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

UPs

print star triangle

Comments (0) |

Inappropriate

Asked By: anujtripathi |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

main()
{
int n,row=1,col=40,i=0,j,k=0,count=1;
int a[10];
clrscr();
i=n-1;
printf("            WELCOME TO THE PROGRAM SIR/MADAM

<BR>);
printf("Pyramid of how many numbers? ");
scanf("%d",&n);
for (j=0;j<n;j++)
{
printf("Enter no.:- ");
scanf("%d",&a[j]);
}
clrscr();
for (row=n;row>=1;row--)
{
k=0;
k=40-(4*(row-1));
i=row-1;
for (col=40;col>=k;col=(col-4))
{
   gotoxy(col,row);
   printf("%d",a[i]);
   --i;
}
}

for (count=n;count>=1;count--)
{
k=0;
k=40+(4*(count-1));
i=count-1;
for (col=40;col<=k;col=(col+4))
{
   gotoxy(col,count);
   printf("%d",a[i]);
   --i;
}
}
getch();
}

Create Date

Thursday, October 16, 2008

Tags

c, c++, star triangle

Asked At

None

Job Positions

None

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

181

UPs

What does static variable mean in C?

Comments (1) |

Inappropriate

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

There are 3 main uses for the static.
1. If you declare within a function:
It retains the value between function calls

2.If it is declared for a function name:
By default function is extern..so it will be visible from other files. if the function declaration is as static, it is invisible for the outer files

3.Static for global variables:
By default we can use the global variables from outside files If it is static global..that variable is limitied to with in the file

Create Date

Tuesday, September 11, 2007

Tags

static variable, function, C, global variables

Asked At

None

Job Positions

None

Click here to improve the Interview Question, Answer and other fields.

Comments (1) :

anujtripathi

Thursday, October 16, 2008 10:42 AM