Geeks Talk

Prepare for your Next Interview


Welcome to the Geeks Talk forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Rows Repeating

This is a discussion on Rows Repeating within the SQL forums, part of the Databases category; i wanted information regarding in one table there records are repeating .but i want to show the records only single time rgds rohit...

Go Back   Geeks Talk > Databases > SQL
Register Blogs FAQ Tag Cloud Calendar Mark Forums Read
  #1 (permalink)  
Old 06-27-2009
Junior Member
 
Join Date: May 2007
Location: bangalore
Posts: 8
Thanks: 0
Thanked 1 Time in 1 Post
rohit_hk77 is on a distinguished road
Rows Repeating

i wanted information regarding in one table there records are repeating .but i want to show the records only single time


rgds
rohit
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 06-27-2009
Contributing Member
 
Join Date: Jun 2009
Location: United States
Posts: 71
Thanks: 0
Thanked 5 Times in 4 Posts
CSOOR is on a distinguished road
Re: Rows Repeating

select distinct * from Table-Name ; this will work in sybase , oracle and MSsql server.
Reply With Quote
  #3 (permalink)  
Old 08-11-2009
Junior Member
 
Join Date: Aug 2009
Location: Delhi
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
sunil.bisht12 is on a distinguished road
Re: Rows Repeating

Hi


you can use the distinct

select distinct(sal) from emp;
Reply With Quote
  #4 (permalink)  
Old 08-29-2009
Junior Member
 
Join Date: Aug 2009
Location: Marhura
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Ajeet.cool is on a distinguished road
Re: Rows Repeating

Yes; This Answer Is Right
Reply With Quote
Reply

  Geeks Talk > Databases > SQL

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
First 3 rows SURJYA SAHOO Oracle 2 03-06-2009 02:11 AM
can we lock rows of a table so that not any instance can even select that rows? UditaOra Oracle 3 07-31-2008 08:32 AM
how to move the particular rows or multiple rows in gridview are selected using check gnanadesigan.k ASP.NET 1 07-18-2008 08:39 AM
Select row by repeating priyasp_msit SQL 3 06-27-2008 06:13 AM
repeating the records in the output table ... rathin007 Data Warehousing 2 10-26-2007 07:01 AM


All times are GMT -4. The time now is 09:37 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.1
Copyright © 2009 GeekInterview.com. All Rights Reserved