Code Snippet posted by:
Denny | Posted on: 6/13/2012 | Category:
SQL Server Codes | Views: 514 | Status:
[Member] |
Points: 40
|
Alert Moderator
select top 1*
from EmpDetails1
where empid not in (
select top (
(select count(*) from EmpDetails1) - 2
) empid
from EmpDetails1
)
create table EmpDetails1(
empid int ,
empname varchar(50),
empimg varchar(50)
);
Regards,
Denny Kurian