Can we use min or max function with count function? In a single query on a column of a table | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Can we use min or max function with count function? In a single query on a column of a table

21st Jul 2016, 6:29 PM
ascetic
ascetic - avatar
3 Answers
0
hello my dear friend min or max function returns only single value ex if your column consist id 1 to 10 then your query is select min(id) from mytable result is 1 select max(id) from mytable result is 10 so u don't have use count function with min or max function
21st Jul 2016, 7:35 PM
ashwath nm
ashwath nm - avatar
0
yes you can use upto 2 levels and make sense using count on max or min when use have used group by clause.
22nd Jul 2016, 5:29 PM
Saurabh Joshi
Saurabh Joshi - avatar
0
Yes u can
20th Aug 2016, 5:41 PM
akash