select top 2 for a single column,,others with all data in sql

Can you explain in a bit more detail what you are trying to accomplish?

try u use select top 2 from your table then use joining..
or else, ellaborate what you want just to be clear..

Select Top 2 [ColumnName] from tblDemo
union
Select * from tblDemo

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.