Answer Posted / ramesh babu

Create table #tempempid(Employeeid int,age int)
Create table #tempempregion(Employeeid int,Region varchar
(200))

Insert into #tempempid(Employeeid,age)values(100,25),
(101,35),(103,35),(104,10),(105,12),(106,11),(107,13),
(108,24),(109,22),(110,17),(111,11),(112,25),(113,100) ,
(52,100)
go
Insert into #tempempregion(Employeeid,region)values
(100,'SA'),(102,'SA'),(103,'UK'),(104,'UK'),(105,'PHL'),
(106,'US'),(107,'US'),(108,'US'),(109,'RSA'),(110,'RSA'),
(111,'UK'),(113,'SA'),(52,'CA')

Select T.region,T.Age from
(
Select b.region as Region,a.age as Age,
rank() over(order by age desc) as Rnk
from #tempempid a inner join #tempempregion b on
a.Employeeid=b.Employeeid
)T
Where T.Rnk=1

What are unicode character string data types in ms sql server?

1142

---

Explain the Ways to improve the performance of a sql azure database?

80

---

Explain how many normalization forms?

968

---

How to define output parameters in stored procedures?

959

---

What is the difference between varchar and nvarchar datatypes?

1033

---

What is difference between order by and group by?

956

---

Write a SQL command to insert and update only a particular field?

1037

---

What are group functions in query statements in ms sql server?

950

---

What is delete query?

896

---

What is the difference between dbcc indexdefrag and dbcc reindex?

930

---

Is truncate a dml command?

889

---

What is clustered index

951

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

1166

---

How you can minimize the deadlock situation?

980

---

Which autogrowth database setting is good?

1002

---