Home » RDBMS Server » Server Administration » repeating values
repeating values [message #369937] Wed, 08 November 2000 14:40 Go to next message
Muhammad Asim
Messages: 6
Registered: November 2000
Junior Member
Hi,
Iam very new to oracle and i got stuck in one query.
i have table in which one field is of date type.i have
to pick that field but when the date repeats.select the
first one for example
date
2-3-99
3-3-99 ->
3-3-99
4-5-99 ->
4-5-99
select the values which have arrows means these are the
values which come first in the table.query will not show the repeating value only the value which come prior.
i will be very thankfull to you if u answer my problem
at my mailing address.(debonair_pk@yahoo.com )
Oracle DBA Opportunities [message #369938 is a reply to message #369937] Wed, 08 November 2000 16:17 Go to previous messageGo to next message
Looking for a better care
Messages: 1
Registered: November 2000
Junior Member
Attention Oracle DBA's:

Due to tremendous business growth in 2000, Management Science Associates in Pittsburgh, PA currently has Oracle DBA opportunities available. For info regarding these and other positions, please see http://www.msa.com/careers/infomgmt.htm#99-A3-977

MSA is not a contract agency or placement company. Established in 1963, MSA is a consistently growing company providing Market Research/Data Analysis and a wide range of Computer Systems Development services to over three hundred clients across the U.S. Our two main locations are within 15 minutes of Downtown Pittsburgh.

MSA’s five divisions service Fortune 500 companies in various industries. Our client base includes companies in the Consumer Packaged Goods Industry such as Bristol-Myers Squibb, R.J. Reynolds, Clairol, Heinz, Kelloggs and many others. Our Media Division's main software product, Gabriel, is marketed to Cable Television and Advertising industry clients such as AT & T Cable, Turner Broadcasting, MTV Networks, ESPN, Lifetime, Discovery Channel, A&E Networks to name a few.

Benefits include:
Competitive Salaries
Choice of Health, Dental & Vision Plans
Matching 401K
Annual Employee Bonus Program
Profit Sharing
Credit Union
Generous vacation/time off policy
Flexible Working Hours
Computer Purchase Discounts
Free Parking
Casual Dress
On-Site Massage

If this sounds like something you may be interested in, please send your resume to careers@msa.com

Sincerely,

Management Science Associates, Inc.
6565 Penn Avenue
Pittsburgh PA 15206
www.msa.com
Re: repeating values [message #369939 is a reply to message #369937] Wed, 08 November 2000 19:26 Go to previous messageGo to next message
Muhammad Asim
Messages: 6
Registered: November 2000
Junior Member
Try this type of query against yout table.
I think this will solve your problem.

Here dat- The date field you want to select
"select dat from emp1 group by dat having count(dat) > 1".

If queries send mail to rparanjo@macromedia.com
Re: repeating values [message #369940 is a reply to message #369937] Wed, 08 November 2000 19:26 Go to previous messageGo to next message
Muhammad Asim
Messages: 6
Registered: November 2000
Junior Member
Try this type of query against yout table.
I think this will solve your problem.

Here dat- The date field you want to select
"select dat from emp1 group by dat having count(dat) > 1".

If queries send mail to rparanjo@macromedia.com
Re: repeating values [message #369941 is a reply to message #369937] Wed, 08 November 2000 19:27 Go to previous messageGo to next message
Muhammad Asim
Messages: 6
Registered: November 2000
Junior Member
Try this type of query against yout table.
I think this will solve your problem.

Here dat- The date field you want to select
"select dat from emp1 group by dat having count(dat) > 1".

If queries send mail to rparanjo@macromedia.com
Re: repeating values [message #369942 is a reply to message #369937] Wed, 08 November 2000 19:27 Go to previous message
Muhammad Asim
Messages: 6
Registered: November 2000
Junior Member
Try this type of query against yout table.
I think this will solve your problem.

Here dat- The date field you want to select
"select dat from emp1 group by dat having count(dat) > 1".

If queries send mail to rparanjo@macromedia.com
Previous Topic: Which is fastest?
Next Topic: replace single quote
Goto Forum:
  


Current Time: Fri May 03 11:15:25 CDT 2024