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.
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: 64151
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
Previous Topic: OLTP,OLAP,ETL and production database
Next Topic: anyone has any training material on oracle manufacturing
Goto Forum:
  


Current Time: Fri Dec 09 21:40:36 CST 2016

Total time taken to generate the page: 0.14730 seconds