| Query [message #337181] |
Wed, 30 July 2008 02:03  |
shahzad-ul-hasan
Messages: 643
Registered: August 2002
|
Senior Member |
|
|
Problem:
Table Fields:
S-no NewRollno Description Year Pre.RNo Reg#
1 233 Metric 2003 093755 0060301-01-2001
2 233 F.Sc 2005 02147 581-Fg-2003
this is data which i store in table. no i want to get the 2nd one row(F.Sc) fileds required
Year, Pre.Rno, Reg# for each student.
But i could not succeed becoz when i applied the query, it will gives following result.
N.Rollno Year Pr.RNo Reg #
233 2005 093755 0060301-01-2001
I want to get this result.
233 2005 02147 581-FG-2003 (REQUIRED RESULT)
pls help me in that query.
regards
Shahzad
|
|
|
|
| Re: Query [message #337204 is a reply to message #337181] |
Wed, 30 July 2008 02:40  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Post what you tried.
Also always post your Oracle version (4 decimals).
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
