Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
LOAD
[Si no], [Email ID], Name, English, Hindi, Maths, Science,max(Science) as Sciencemax
FROM
(ooxml, embedded labels, table is Sheet1);
Iam not able to display the results of " min(Science) " command. its displaying error....
HELP
for this u need to use Group By Clause after the
LOAD
[Si no], [Email ID], Name, English, Hindi, Maths, Science,max(Science) as Sciencemax
FROM
(ooxml, embedded labels, table is Sheet1)
Group By
[Si no], [Email ID], Name, English, Hindi, Maths;
for this u need to use Group By Clause after the
LOAD
[Si no], [Email ID], Name, English, Hindi, Maths, Science,max(Science) as Sciencemax
FROM
(ooxml, embedded labels, table is Sheet1)
Group By
[Si no], [Email ID], Name, English, Hindi, Maths;
hi,
to use aggregate functions like min, max count, we have to use group by cluase.
so
first u load:
Student:
LOAD
[Si no], [Email ID], Name, English, Hindi, Maths, Science
FROM
(ooxml, embedded labels, table is Sheet1);
Then load
load [Si no],
max(Science) As Sciencemax
resident Student
group by [Si no];
hope it helps you.
Niranjan M.
hi,
use according to this example,
Load Month, min(Sales) as SmallestSalePerMonth from abc.csv group by Month;
Load Month, min(Sales, 2) as SecondSmallestSalePerMonth from abc.csv group by Month;
hope it help you.
Is it compulary to use a group by statement? Is there any alternative way without using group by...