NSingh

 Profile Answers by NSingh 

• Dec 21st, 2010

 

In SQL Server you can use this query:- select max(s.sno) from (select row_number() over(order by col_name) as sno from tab_name) s

nirmal1in

 Profile Answers by nirmal1in Questions by nirmal1in

• Dec 25th, 2010

 

Below are the two alternative methods can be used to get the count of records from table without using count function

Method 1 :

select max(count) from

(select row_number() over (order by 1) count

from emp1)

Method 2 :

select sum(case when empname is null then 1

else 1 end)

from emp1;

Subashpanda

 Profile Answers by Subashpanda Questions by Subashpanda

• Feb 3rd, 2011

 

Select MAX(rownum) from tablename;

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

Select MAX(rownum) from tablename;

Sujaya

• Jun 8th, 2012

 

Simple use the following command:
SELECT COUNT(*) From Emp;

smily08

 Profile Answers by smily08 

• Aug 30th, 2012

 

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

Sandipan

• Sep 6th, 2012

 

Select sum(1) from emp;

Code
SELECT sum(1) FROM emp;