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 the query for retrieve the unique values(not display the duplicates values) from single table?

6 Answers   IBM,


Can you fastexport a field, which is primary key by putting equality on that key?

0 Answers  


Does SDLC changes when you use Teradata instead of Oracle?

2 Answers  


What is FILLER command in Teradata?

9 Answers   CTS, IBM,


What are the different functions performed in development phase?

0 Answers  






What is meant by Teradata Gateway?

0 Answers  


What is the use of fallback?

0 Answers  


Explain fallback in teradata?

0 Answers  


What is the use of having index on table?

0 Answers  


In BTEQ, how are the session-mode parameters being set?

0 Answers  


Why do you get spool space errors? How do trouble-shoot them?

0 Answers  


How to select first n records in teradata?

0 Answers  


Categories