Register

Aggregate function

• edited by
484 views

1 Answer

0 votes
0 votes
C] SELECT MAX(salary) FROM INSTRUCTORS;

D] SELECT *FROM INSTRUCTORS HAVING salary=MAX(salary);
• edited by
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

460
views
1 answers
0 votes
atul_21 asked Sep 21, 2017
460 views
Aggregate function
Answer given is C . But count will ignore the null values therefore using sum and count, result must be greater . Am i right??
User Avatar
1.6k
views
2 answers
2 votes
set2018 asked Jul 21, 2017
1,596 views
Aggregate function
Can we apply min and max (aggregate function in sql) on strings and date datatype ?Query :SELECT max(Name) FROM EMPLOYEEwhat will be the result ?
User Avatar
1.5k
views
1 answers
2 votes
rohan mishra asked Jul 8, 2017
1,476 views
sql aggregate function
Given a column consisting of 12,19,12,13,14,NULL,NULL. What will be the answer1.If we apply count on the column.2.If we apply sum on the column.3 ... apply count(*) on the column.Please provide the explanation whether to count null or not.
User Avatar
2.4k
views
4 answers
2 votes
Keith Kr asked Jan 31, 2015
2,417 views
True or False: Relational algebra cannot perform aggregate function
True or False: Relational algebra cannot perform aggregate function
User Avatar
Link Copied!