The number of records or rows in a table using MySQL can be got by using the COUNT statement.
Explanation:
- To counts all of the rows in a table, whether they contain NULL values or not, use COUNT
- That form of the COUNT() function basically returns the number of rows in a result set returned by a SELECT statement
- The SQL COUNT() function returns the number of rows in a table satisfying the criteria specified in the WHERE clause.
- It sets the number of rows or non NULL column values.
- COUNT() returns 0 if there were no matching rows.
- The SQL COUNT function is an aggregate function that returns the number of rows returned by a query. You can use the COUNT function in the SELECT statement to get the number of employees, the number of employees in each department, the number of employees who hold a specific job, etc.
A place where young plants are produced through different ways is a nursery. The main work of nursery is to supply young plants and seeds for cultivation purposes for both fruits and vegetables. ... An appropriate environment for germination of seed. The nursery is also very useful for purpose of vegetation propagation.
Answer:
// program in C++.
// headers
#include <bits/stdc++.h>
using namespace std;
// main function
int main()
{
// Variable
int num;
cout << "Enter a number between 1 and 10: ";
// read input
cin >> num;
// validate input number
while(num<1||num>10)
{
// if input is wrong then print error message
cout<<"Wrong input!!Enter again:";
// read again
cin>>num;
}
// print output
cout << "The Roman numeral for "<<num<<" is:";
// switch
switch (num)
{
case 1:
// if input is 1
cout<<"I"<<endl;
// exit the switch
break;
case 2:
// if input is 2
cout<<"II"<<endl;
// exit the switch
break;
case 3:
// if input is 3
cout<<"III"<<endl;
// exit the switch
break;
case 4:
// if input is 4
cout<<"IV"<<endl;
// exit the switch
break;
case 5:
// if input is 5
cout<<"V"<<endl;
// exit the switch
break;
case 6:
// if input is 6
cout<<"VI"<<endl;
// exit the switch
break;
case 7:
// if input is 7
cout<<"VII"<<endl;
// exit the switch
break;
case 8:
// if input is 8
cout<<"VIII"<<endl;
// exit the switch
break;
case 9:
// if input is 9
cout<<"IX"<<endl;
// exit the switch
break;
case 10:
// if input is 10
cout<<"X"<<endl;
// exit the switch
break;
// default
default:
break;
}
return 0;
}
Explanation:
Read a number from usr and assign it to variable "num". If the input number is less than 1 or greater than 10 then ask again to enter a number until user enter a number between 1-10 only.Then with the help of switch() function print the equivalent Roman number.
Output:
Enter a number between 1 and 10: -5
Wrong input!!Enter again:12
Wrong input!!Enter again:6
The Roman numeral for 6 is:VI
Answer is Formatting
When conditional formatting is applied to your data, you can
quickly and easily identify variances in different values within a quick glance.
This makes worksheets easier to comprehend. With conditional formatting, you
are able to apply formatting such as icons, data bars, and colors.
Answer:
Ctrl + R - Copy a formula from the cell to the left and adjusts the cell references. For example, if you have a formula in cell A2 and you want to copy it to cell B2, select B2 and press Ctrl + R. Tip. Both of the above shortcuts can be used to copy formulas to multiple cells too.
Explanation:
