Login
Login
Register
Questions
Unanswered
Tags
Categories
Ask a Question
Ask a Question
Recent questions tagged built in functions
+2
votes
1
answer
(i) Name any two Aggragate functions of SQL. (ii) Consider the table
asked
Apr 7, 2019
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+1
vote
1
answer
Write the output of the following SQL queries.
asked
Mar 29, 2019
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+1
vote
1
answer
Explain concat function.
asked
Feb 20, 2019
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+3
votes
1
answer
What is the result of the expression MOD (57,2)?
asked
Feb 20, 2019
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+2
votes
1
answer
Write the output of the following SQL queries.
asked
Feb 8, 2019
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+3
votes
1
answer
A numeric data field AMOUNT store a value 205.98. Round it *** using MySQL to :
asked
Feb 4, 2019
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+3
votes
1
answer
What is "SQL"?
asked
Jan 28, 2019
in
Class 12
by
kratos
built in functions
management system
cbse
class-12
relational database
+3
votes
1
answer
What will be the output of the following code ? > SELECTCONCAT(CONCAT('I', 'love'), 'SQL');
asked
Jan 13, 2019
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+3
votes
1
answer
What will be the output of : (i) SELECT ROUND (124.44) + MOD (1200.87,3) (ii) SELECT (MOD (30.500, 5) + ROUND (100.50, 1)
asked
Jan 8, 2019
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+3
votes
1
answer
What is the difference between CURDATE() and DATE() functions?
asked
Jan 1, 2019
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+1
vote
1
answer
Write the meaning of the following statement: "MySQL is released under an open-source license."
asked
Dec 27, 2018
in
Class 12
by
kratos
management system
cbse
built in functions
data definition language
data manipulation language
class-12
relational database
+3
votes
1
answer
Write the name of functions which : (i) returns length of a string (ii) returns specified number of character from a string.
asked
Dec 11, 2018
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+3
votes
1
answer
What is the use of functions LCASE ( ) and UCASE()?
asked
Nov 6, 2018
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+1
vote
1
answer
Write the output of the following SQL queries :
asked
Oct 22, 2018
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+3
votes
1
answer
Write the output of the following SQL queries:
asked
Oct 20, 2018
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+1
vote
1
answer
Write the output of the following SQL queries :
asked
Oct 7, 2018
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+2
votes
1
answer
Name a function used to give the first occurence of string 2 in string 1.
asked
Oct 1, 2018
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+2
votes
1
answer
Write the output of the following SQL queries: SELECT POW(INSTR('My_Datababse',' _' ),2) ;
asked
Sep 13, 2018
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+3
votes
1
answer
Consider the table 'Organization' :
asked
Sep 10, 2018
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
+2
votes
1
answer
Name a function of MySql which is used to remove trailing and leading spaces from a string.
asked
Jul 8, 2018
in
Class 12
by
kratos
management system
cbse
built in functions
class-12
relational database
To see more, click for the
full list of questions
or
popular tags
.