Hi frnds,
Create Table #City(CityName varchar(40))
insert into #City
select top 5 City from State where Name='TamilNadu' order by City
insert into #City
select top 5 City from State where Name='Kerala' order by City
Select Top 5 * from #City order by City
Frnds this is sample Query ,
in my SQL Server database around 5laks records is there , when i get all data from table and fetch top 5 records means it will take long time to execute
how can i execute these 2 queries in same time .