Home » SQL & PL/SQL » SQL & PL/SQL » Query
Query [message #337181] Wed, 30 July 2008 02:03 Go to next message
Messages: 494
Registered: August 2002
Senior Member
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.

Re: Query [message #337204 is a reply to message #337181] Wed, 30 July 2008 02:40 Go to previous message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
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).

Previous Topic: setting constraint
Next Topic: Help Needed in Select
Goto Forum:

Current Time: Mon Jul 24 22:13:47 CDT 2017

Total time taken to generate the page: 0.20802 seconds