How to count number of records in a table without using COUNT function?

Sandipan

• Sep 6th, 2012

Select sum(1) from emp;

Code
SELECT sum(1) FROM emp;

smily08

 Profile Answers by smily08 Questions by smily08

• Aug 30th, 2012

Select max(rownum) from
(select ROW_NUMBER() over (order by col_name) as rowNum from table_name)
withRowNum

Answer Question  Select Best Answer

What are all the different ways available to find the null value in a table

NSingh

 Profile Answers by NSingh Questions by NSingh

• May 22nd, 2010

select * from tab_namewhere col_name is null

psingla

 Profile Answers by psingla Questions by psingla

• May 6th, 2010

In pl/sql:"is null" and "is not null" are the best way to find null and not null values resp.In t-sqlif ansi_nulls is off then(set ansi_nulls off)"=" will work to search the null values

Answer Question  Select Best Answer

How can I select column values from a table without knowing the column name ?Suppose , select employee_id from employees , now I don't know the column name and I want to select the column.Please let me know the answer

suganthi

• Jul 3rd, 2015

How to display data from table values without using select command?

kranthiswaroop

 Profile Answers by kranthiswaroop Questions by kranthiswaroop

• May 6th, 2014

Hi Sanjoy, Its a simple logic that, one should have complete idea about the Table , Table fields and data types used.. before applying any DML DCL DDL Commands, a programmer shoud know this. A progra...

Answer Question  Select Best Answer