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
7134 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 are the joins in teradata and how many types of joins are there in teradata?

1008

What are the different design perspectives used in teradata?

983

Describe primary index in teradata. And what are the available primary index types?

1004

What are the functions performed by bynet?

1043

How many types of joins are there in teradata?

978

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

1048

Can we collect statistics on multiple columns?

1067

Difference between inner join and outer join?

1033

Why is the case expression used in teradata?

1078

Explain Teradata performance tuning and optimization?

1171

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1043

What is the difference between teradata and oracle?

1028

How to find duplicates in a table?

1218

Difference between star and snowflake schemas?

1156

How do you determine the number of sessions?

1064