Hi Sanjiv, you can use analytic function:
*select id, name, salary, count(1) over() as cnt from t* or even *select *, count(1) over() as cnt from t* You can you star instead of 1 as well (*select *, count(*) over() as cnt from t*) Kind regards Arina On Tue, Jan 17, 2017 at 1:36 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. >
