How to use Distinct and Top jointly in Sql

See more:

SQL-Server-2005

SQL

SQL-Server

Hello Every one

I am facing a problem where i need a sql query which have implemented both distinct and top jointly.
I have two tables having one to many relationship the First table

My First Table is as under

CREATE TABLE [dbo].[tbl_Cars](
	[CarId] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[CarVinNumber] [varchar](100) NOT NULL,
	[CarMakeId] [numeric](18, 0) NOT NULL,
	[CarModelId] [numeric](18, 0) NOT NULL,
	[CarTypeId] [numeric](18, 0) NOT NULL,
	[CarDoors] [int] NOT NULL,
	[CarStatusId] [numeric](18, 0) NOT NULL,
	[CarOriginalPrice] [decimal](18, 0) NOT NULL,
	[CarOfferedPrice] [numeric](18, 0) NOT NULL,
	[CarMileage] [numeric](18, 0) NOT NULL,
	[CarFuelType] [varchar](50) NOT NULL,
	[CarEngineSize] [varchar](500) NOT NULL,
	[CarAvailableTransmission] [varchar](500) NOT NULL,
	[CarFuelEconomyCity] [decimal](18, 0) NULL,
	[CarFuelEconomyHighway] [decimal](18, 0) NULL,
	[CarColorInterior] [varchar](20) NOT NULL,
	[CarColorExterior] [varchar](20) NOT NULL,
	[CarCylinders] [int] NOT NULL,
	[CarBodyStyle] [varchar](50) NOT NULL,
	[CarNewOrUsed] [varchar](20) NOT NULL,
	[CarAdditionalDetails] [varchar](1000) NOT NULL,
	[CarAddress] [varchar](500) NOT NULL,
	[CarYear] [int] NOT NULL,
	[CarInsertiondateTime] [date] NOT NULL,
	[CompanyId] [numeric](18, 0) NOT NULL,
	[CarInsertedById] [numeric](18, 0) NOT NULL,
	[CarDriveTrain] [varchar](50) NOT NULL,
 CONSTRAINT [PK_tbl_Cars] PRIMARY KEY CLUSTERED 
(
	[CarId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

My Second Table in which The Car Id from the above table is the foriegn key

CREATE TABLE [dbo].[tbl_Car_Image](
	[CarImageId] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[CarId] [numeric](18, 0) NOT NULL,
	[CarThmb_ImagePath] [varchar](200) NOT NULL,
	[CarImagePath] [varchar](200) NOT NULL,
	[CompanyId] [numeric](18, 0) NOT NULL,
 CONSTRAINT [PK_tbl_Car_Image] PRIMARY KEY CLUSTERED 
(
	[CarImageId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

I have create a view but that displays all the redundant CarId rows, but i Need a dataset where for each CarId it Merges only one row from the CarImageTable (I mean the second Table). I tried Distinct and top on the view whcih i have created but that is not displaying distinct records based on CarID

Regards
TanzeelurRehman