This problm solve only using Distinct or Group by syntax: 1:sel distinct

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 / ankal

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you create tables? Exact syntax, and create profiles, users in teradata?

1089

What are the string manipulation operators and functions associated with teradata?

1149

When tpump is used instead of multiload?

1144

What is bteq script in teradata?

1212

What is database exceptions in teradata?

1000

What is basic teradata query language?

1164

how do you manage the production space. what are the proactive methods you can take ?

1981

Explain the term 'tables' related to relational database management system?

1103

What is called partitioned primary index (ppi)?

1055

How is MLOAD Teradata Server restarted after execution?

1342

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3694

How many tables can you join in v2r5?

1117

What are the steps to create a data model?

1107

Explain amp in teradata?

1151

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1156