what is the syntax used for partition in tsql? : Transact sql

0 Answers  

---

define data blocks ? : Sql dba

0 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,

---

What does select top 1 do in sql?

0 Answers  

---

Can we call procedure in select statement?

0 Answers  

---

how to write utl file pkg in SQL

1 Answers   Oracle,

---

What does subquery mean in sql?

0 Answers  

---

What is the difference between left join and right join?

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

Define overloaded procedure?

0 Answers  

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

---