Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


one table have
input
no name
10 rao
20 siva
30 srinu
10 rao
i want to ouput like this way
no name
20 siva
30 srinu
10 rao
how it posible in only sql server query?not oracle?

Answers were Sorted based on User's Feedback



one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput lik..

Answer / babu

Hi,

sel no,name from table group by no,name order by no,name;

Is This Answer Correct ?    6 Yes 3 No

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput lik..

Answer / ankal

This problm solve only using Distinct or Group by
syntax:
1:sel distinct no,name from tablename;
2:sel no,name from tablename group by no,name;

Is This Answer Correct ?    3 Yes 1 No

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput lik..

Answer / tdguy

use distinct or group by to avoid duplicates in teradata.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Teradata Interview Questions

what is object level locking ? where do appear this type of locking ?

0 Answers  


any one pls tell me what are the table names in banking project?

2 Answers  


What is the use of having index's on table?

1 Answers  


we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

5 Answers   Accenture, Cognizant,


How will you solve the problem that occurs during update?

0 Answers  


What does Amp contain and what are all the operations that it performs?

0 Answers  


List out teradata data types?

0 Answers  


what is identity columns in teradata

2 Answers   Wipro,


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

0 Answers   IBM,


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

0 Answers  


What are the different methods ot loading a dimension table? A fact table etc?

0 Answers  


Differentiate primary key and partition key?

0 Answers  


Categories