one table have input no name 10 rao 20 siva 30 srinu 10 rao

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?

Question Posted / guest

3 Answers
5943 Views
IBM, I also Faced
E-Mail Answers

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