Home » SQL & PL/SQL » SQL & PL/SQL » Query
Query [message #337181] Wed, 30 July 2008 02:03 Go to next message
shahzad-ul-hasan
Messages: 464
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 Go to previous message
Michel Cadot
Messages: 64111
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).

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


Current Time: Mon Dec 05 13:12:26 CST 2016

Total time taken to generate the page: 0.06711 seconds