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 ssrs maintain security?

0 Answers  

---

How do you create type- insensitive operator?

0 Answers   EXL,

---

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

---

Can we update data in a view?

0 Answers  

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---

How to maintain a fill factor in existing indexes?

0 Answers  

---

Does sql server use t sql?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

What is the use of SCOPE_IDENTITY() function?

2 Answers  

---

How to create dbo table in sql server?

0 Answers  

---

How to divide query output into multiple groups with the group by clause in ms sql server?

0 Answers  

---

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

---