OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Urgent help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Urgent help [message #212601]

Sat, 06 January 2007 05:56

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)

Report message to a moderator

Re: Urgent help [message #212602 is a reply to message #212601]

Sat, 06 January 2007 06:43

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator