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
6947 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 do high confidence, low confidence and no confidence mean in explain plan?

980

Describe the set operators in teradata.

952

What is basic teradata query language?

1032

What is the difference between teradata and basic rdbms?

950

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

1040

What are the available join types in teradata?

1011

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3315

What is the purpose of joins in teradata?

1067

In general, how do you optimze any sql in teradata?

974

Explain vproc in teradata?

939

What are the primary characteristics of the Teradata.

1058

What is node? How many nodes and amps used in your previous project?

1061

What is oltp?

914

What is difference between user and database in teradata?

1025

What are default access rights in teradata? What explicit right can be given to a user?

1057