| Oracle help [message #6872] |
Fri, 09 May 2003 07:16  |
Nazma Bepat
Messages: 34
Registered: May 2003
|
Member |
|
|
I have a question:
I need a query to display the student’s data for three specific students.
This is what I cam up with:
Select student_data
From student
Where student = specific_data
This does not work for me.
Can someone please help me out.
Thanks
Nazma
|
|
|
|
| Re: Oracle help [message #6887 is a reply to message #6872] |
Sat, 10 May 2003 01:17  |
jigar
Messages: 74
Registered: July 2002
|
Member |
|
|
I guess you want to show the data of three students whose Student ID you have.
If yes, you can try this
Select student_data
From student
Where student in (1,2,3)
--here 1 , 2 and 3 is the ID of three different students.
Regards,
Jigar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
