Home » SQL & PL/SQL » SQL & PL/SQL » Urgent help
Urgent help [message #212601] Sat, 06 January 2007 05:56 Go to next message
sdey.143
Messages: 2
Registered: January 2007
Location: Uttarpara
Junior Member
Pls send me
1 how to select duplicate row from a table? with example(syntax)
2 how to select nth row or 5th row of a table? with example(syntax)
3 how to get summary of rows for a dept no in emp table? with example(syntax)
Re: Urgent help [message #212602 is a reply to message #212601] Sat, 06 January 2007 06:43 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
1. Search the forum for 'Having'
2. There is no such thing like first row, second row or nth row in Oracle. You need to have an 'order by' on some column.
3. Summary? Sum of salary? Number of employees? What kind of summary you need?

By
Vamsi
Re: Urgent help [message #212610 is a reply to message #212602] Sat, 06 January 2007 09:30 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Would you like a few of us to sing in a choir in the background while Vamsi does your homework? ./fa/1963/0/
Re: Urgent help [message #212612 is a reply to message #212601] Sat, 06 January 2007 09:48 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
many fine coding examples can be found at http://asktom.oracle.com
Re: Urgent help [message #212616 is a reply to message #212610] Sat, 06 January 2007 10:04 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Littlefoot wrote on Sat, 06 January 2007 16:30
Would you like a few of us to sing in a choir in the background while Vamsi does your homework? ./fa/1963/0/

hehe
Previous Topic: How to convert VARCHAR2 to BLOB ?
Next Topic: joining multiple tables
Goto Forum:
  


Current Time: Fri Dec 09 23:03:22 CST 2016

Total time taken to generate the page: 0.08590 seconds