Database

select top 1 * from (select top 6 * from employee order by salary desc) as s order by salary asc

select * from (select count(*) as Duplicates, * from Employee group by name,salary) as tbl where Duplicates > 1

Select top 5 LastName,  count (*) as [Count] from TBL where lastname = 'Cruz'<br />
group by lastname order by [Count]  Desc

Select top 5 LastName, count (*) as [Count] from TBL where lastname = 'Cruz'<br />
group by [Count]

CandyMe wrote:

Select top 5 LastName, (Select count (*) from TBL where lastname = 'Cruz') as Count from TBL where lastname = 'Cruz'

CandyMe wrote:

I mean my query doesn't work and have researched over the internet.

Select top 5 LastName, <br />
(Select count (*) from TBL where lastname = 'Cruz') as Count <br />
from TBL where lastname = 'Cruz'

insert into mytesttable (MyDateField) values (getdate())

CREATE TABLE [MyTestTable] (
    [IDColumn] [int] IDENTITY (1, 1) NOT NULL ,
    [DateCreated] AS (getdate())
) ON [PRIMARY]