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

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

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

Answer Posted / babu

Hi,

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

Is This Answer Correct ?

6 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is meant by a Channel Driver?

1219

What do high confidence, low confidence and no confidence mean in explain plan?

1035

What is partitioned primary index (ppi)?

1039

What are the joins in teradata and how many types of joins are there in teradata?

993

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1058

What are some commonly used bteq scripts?

991

How you will check the version of teradata?

1145

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

970

Why does varchar occupy 2 extra bytes?

1168

What is multi insert?

1032

Highlight the points of differences between the database and user in Teradata.

1093

What is dimensional modeling?

1062

What is the use of stored procedures in teradata?

985

What are different table types used in teradata?

1024

What are the steps to create a data model?

1029