Home » Other » Training & Certification » Basic SQL statement , Finding Repeated Values (oracle9i, winxp)
Basic SQL statement , Finding Repeated Values [message #302146] Sun, 24 February 2008 03:10 Go to next message
oraclewannabe
Messages: 26
Registered: January 2008
Junior Member
Hi guys, I have a table with columns
user_id (varchar2) and mobileno(varchar2).

A user may have more then 1 mobile number.
How do i my sql statement such that i can..

1) see each and every exact mobile number of a particular user without repeating the user_id everytime a row is shown.

2) see the AMOUNT of mobile number own by a particular user ?

3) see the AMOUNT of mobile number own by every user in the table?

Thanks Pals! this forum really has the fastest respond rate.

Report message to a moderator

Re: Basic SQL statement , Finding Repeated Values [message #302148 is a reply to message #302146] Sun, 24 February 2008 03:15 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) BREAK SQL*Plus command or use DECODE and LAG function
2) COUNT function
3) COUNT function and GROUP BY

Regards
Michel

Report message to a moderator

Previous Topic: OLTP,OLAP,ETL and production database
Next Topic: anyone has any training material on oracle manufacturing
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 13:15:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.