Answer / syeda

Need to define a relationship to the table and common column
of tables

ex : there is a table called college which contains the
college records like studid, studentname, batch & course.
And other table called student_details which contains
studid, firstName, lastName, fathersName, mothersName, DOB,
ContactNo & address.

Here we are fetching studid, batch, course & studentname
from collete table and DOB, ContactNo & address from
students_details , of all the students whose birth month is
April 1988

Syntax : select
a.studid,a.batch,a.course,a.studentname,b.DOB,b.ContactNo,b.address
from college a, student_details b where a.studid=b.studid
and b.DOB like '%-Apr-1988'

Answer / jagadeesh

SubQuery

How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  

---

query processing

0 Answers  

---

How you provide security to cube? : sql server analysis services, ssas

0 Answers  

---

How to skip remaining statements in a loop block using continue statements?

0 Answers  

---

What is a NOLOCK?

3 Answers   NA,

---

What stored by the msdb? : sql server database administration

0 Answers  

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

How to rebuild indexes with alter index ... Rebuild?

0 Answers  

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---

Explain the steps to use transact-sql cursor?

0 Answers  

---

What is difference between aggregate and analytic function?

0 Answers  

---