Hello Arina
Thanks for reply. I have tried over() it working fine with
single table, but when i used join then the other table column showing null
value.
See This Example:-
SELECT (CAST(T2.`ID` AS BIGINT)) AS `No of
Order`,T2.WebsiteID,count(*) over() FROM
<pluginName>.<dbName>.<schemaName>.<tableName1> AS T2;
This Working fine.
But If i used Join..
See This Example:-
SELECT (CAST(T2.`ID` AS BIGINT)) AS `No of
Order`,T2.WebsiteID,T3.`Name` AS `Name`,count(*) over() FROM
<pluginName>.<dbName>.<schemaName>.<tableName1> AS T2 INNER JOIN
<pluginName>.<dbName>.<schemaName>.<tableName2> AS T3 ON T3.`ID` =
T2.`WebsiteID`;
In this query T3.Name from Table2 showing blank.
On Tue, Jan 17, 2017 at 5:06 PM, Sanjiv Kumar <sanjiv...@gmail.com> wrote:
> Hello
> I want to know.. Can i get all column name and column count in
> single select statement??
>
> Example:-
> I have table having total 10 rows and Id, Name, Salary
> Column.
>
> Now, Can i write single query to get all th column name (Id, Name, Salary)
> and total count of rows(i.e:- 10) ?
>
> ex:- select T1.Id, T1.Name, T1.Salary, Count(*) from
> <pluginName>.<schemaName>.<tableName>
>
> Can anyone tell the solution.??
>
> --
> Thanks & Regards.
> Sanjiv Kumar.
>
--
Thanks & Regards.
Sanjiv Kumar.
