Saturday, 13 April 2013

How to find the 5 th MAX Salary in sql server 2008



create table Employee2000 (eno int,ename varchar(30),Sal int );

insert into Employee2000 values (1,'ANIL',25000)
insert into Employee2000 values (2,'SUNIL',24000)
insert into Employee2000 values (3,'Rajesh',23000)
insert into Employee2000 values (4,'Kamesh',22000)
insert into Employee2000 values (5,'RUPESH',21000)










select sal from Employee2000 e1 where 4=(select COUNT(*) from Employee2000 f1 where e1.Sal<f1.Sal)



How to find the N th record in sql server 2008


SQLDBA - create the temp db files dynamically

 Below script will  be help full for creating temp DB files for specified count  DECLARE @tempdbfilecount INT; DECLARE @tempdatadir ...