Login
Login
Register
Questions
Unanswered
Tags
Categories
Ask a Question
Ask a Question
Recent questions tagged grouping records
+3
votes
1
answer
How is NULL value different from 0 (zero) value?
asked
Apr 4, 2019
in
Class 12
by
kratos
management system
cbse
class-12
relational database
grouping records
+1
vote
1
answer
How are NULL values treated by aggregate functions ?
asked
Mar 30, 2019
in
Class 12
by
kratos
management system
cbse
class-12
relational database
grouping records
+1
vote
1
answer
Consider the table given below :
asked
Mar 14, 2019
in
Class 12
by
kratos
management system
cbse
data manipulation language
class-12
relational database
grouping records
+2
votes
1
answer
What is the purpose of ORDER BY clause in MySQL? How is it different from GROUP BY clause?
asked
Feb 1, 2019
in
Class 12
by
kratos
management system
cbse
class-12
relational database
grouping records
+1
vote
1
answer
Why are aggregate functions called so? Name some aggregate functions.
asked
Dec 30, 2018
in
Class 12
by
kratos
.
management system
cbse
structured query language
data manipulation through sql
class-12
relational database
grouping records
+3
votes
1
answer
Table Employee has 4 records and Table Dept has 3 records in it.
asked
Dec 29, 2018
in
Class 12
by
kratos
management system
cbse
data manipulation language
class-12
relational database
grouping records
+3
votes
1
answer
Consider the tables'Flights' & 'Fares' given below:
asked
Dec 18, 2018
in
Class 12
by
kratos
management system
cbse
data manipulation language
class-12
relational database
grouping records
+2
votes
1
answer
Ms. Shalini has just created a table named “Employee” containing columns Ename, Department, Salary.
asked
Nov 29, 2018
in
Class 12
by
kratos
management system
cbse
structured query language
class-12
data file handling
relational database
grouping records
+3
votes
1
answer
There is a column Salary in a Table EMPLOYEE. The following two statements are giving different outputs.
asked
Nov 19, 2018
in
Class 12
by
kratos
management system
cbse
data manipulation language
class-12
relational database
grouping records
+3
votes
1
answer
Is NULL and 0(zero) same justify your answer.
asked
Nov 12, 2018
in
Class 12
by
kratos
management system
cbse
class-12
relational database
grouping records
+1
vote
1
answer
Why is it not allowed to give String and Date type arguments for SUM() and AVG() functions? Can we give these type of arguments for other functions ?
asked
Nov 4, 2018
in
Class 12
by
kratos
management system
cbse
class-12
relational database
grouping records
+1
vote
1
answer
What is the difference between HAVING and WHERE clauses? Explain with the help of an example.
asked
Oct 1, 2018
in
Class 12
by
kratos
management system
cbse
class-12
relational database
grouping records
+1
vote
1
answer
Can a GROUP BY clause be used for more than one column? Give example.
asked
Sep 14, 2018
in
Class 12
by
kratos
management system
cbse
class-12
relational database
grouping records
+2
votes
1
answer
Given below is a Table Patient :
asked
Aug 28, 2018
in
Class 12
by
kratos
management system
cbse
concept of database
class-12
relational database
grouping records
+3
votes
1
answer
Write the purpose of ORDER BY clause using suitable example.
asked
Aug 25, 2018
in
Class 12
by
kratos
management system
cbse
class-12
relational database
grouping records
+2
votes
1
answer
Why are aggregate functions called so? Name some aggregate functions.
asked
Aug 10, 2018
in
Class 12
by
kratos
management system
cbse
class-12
relational database
grouping records
+3
votes
1
answer
Gopi Krishna is using a table Employee. It has the following columns: Code, Name, Salary, Deptcode.
asked
Aug 5, 2018
in
Class 12
by
kratos
management system
cbse
class-12
relational database
grouping records
+2
votes
1
answer
What is meant by NULL value in MySQL ?
asked
Jun 8, 2018
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
grouping records
+3
votes
1
answer
There is a column C1 in a table T1. The following two statements: SELECT COUNT(*) FROM T1;
asked
May 18, 2018
in
Class 12
by
kratos
management system
cbse
class-12
relational database
grouping records
+1
vote
1
answer
Consider the table 'Hotel' given below :
asked
Mar 24, 2018
in
Class 12
by
kratos
management system
cbse
class-12
relational database
grouping records
To see more, click for the
full list of questions
or
popular tags
.