Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to select top 5 coloumn from a table without using
coloumn name

Answer Posted / dj

Select Top(5) COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS
Where TABLE_NAME = 'Emp';

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does indexation mean?

949


How to transfer data from a cursor to variables with a "fetch" statement?

1070


Do you know what is a trace frag? Where do we use it?

979


What is user-defined functions? What are the types of user-defined functions that can be created?

1015


How many databases Microsoft SQL server provides?

1065


Do you know how to send email from database?

963


What is indexing a document?

1015


What is difference between equi join and inner join?

914


Explain the dirty pages?

981


How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1076


How can I add Reporting Services reports to my application?

129


what are different types of raid configurations? : Sql server database administration

1033


Can we insert data into view sql server?

909


What do you mean by authentication modes in sql server?

1063


Can group functions be used in the order by clause in ms sql server?

993