Answer / grace

SELECT A.*
FROM dbo.T1 A
WHERE CustomerID IN
(SELECT TOP 10 CustomerID FROM dbo.T1 WHERE City=A.City)

Answer / asim

select id,addressid,city
from
(
SELECT ROW_NUMBER() OVER (partition by city Order by
addressid) ID,AddressID,City
FROM person.Address A
WHERE City IN
(select city from person.address group by City

) )a
where a.ID <11
order by City,ID

Answer / jyoti

CREATE TABLE #CustDetails
(
CustID INT IDENTITY(1,1),
CustName VARCHAR(10),
City VARCHAR(10)
)

INSERT INTO #CustDetails
SELECT 'A1','Pune' UNION ALL
SELECT 'A2','Pune' UNION ALL
SELECT 'A3','Pune' UNION ALL
SELECT 'A4','Pune' UNION ALL
SELECT 'A5','Pune' UNION ALL
SELECT 'A6','Pune' UNION ALL
SELECT 'B1','Delhi' UNION ALL
SELECT 'B2','Delhi' UNION ALL
SELECT 'B3','Delhi' UNION ALL
SELECT 'B4','Delhi' UNION ALL
SELECT 'B5','Delhi' UNION ALL
SELECT 'B6','Delhi' UNION ALL
SELECT 'B7','Delhi' UNION ALL
SELECT 'B8','Delhi' UNION ALL
SELECT 'C1','Mumbai' UNION ALL
SELECT 'C2','Mumbai' UNION ALL
SELECT 'C3','Mumbai' UNION ALL
SELECT 'C4','Mumbai' UNION ALL
SELECT 'C5','Mumbai'

SELECT
ID,CustName,City
FROM
(
SELECT
ROW_NUMBER() OVER (PARTITION BY CITY ORDER
BY CustID DESC) ID,CustName,City
FROM
#CustDetails AS CD1
) A
WHERE A.ID < 3

Answer / rakesh ameta

create table newq(ids numeric(5),sname nvarchar(10),city nvarchar(10))

select * from newq where newq.ids in(select top 10 ids from newq x where newq.city=x.city)

Answer / ravi kumar ravuri

select * from Customer where Customer_ID in (select top 10
from Customer Where City_name in ( select City_Name from
Customer Group by City_Name))

Answer / abhijith

select top 10
from tablename
where city IN
(select distinct(city) from tablename)

Answer / abhijith

select top 10 *
from tablename
where city IN
(select distinct(city) from tablename)

Answer / sonal parekh

select Top 10 CustomerName, city from customer

How and why use sql server?

0 Answers  

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  

What is Command line parameters in PLSQL.?

0 Answers   MCN Solutions,

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

Explain view in sql server?

0 Answers  

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

What is db stored procedure?

0 Answers  

How do I setup a local sql server database?

0 Answers  

Call by value and call by reference in procedure and function, with NOCOPY.

0 Answers   Nagarro,

What is data file in computer?

0 Answers  

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  

Explain intellisense for query editing

0 Answers