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
7270 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 the purpose of indexes?

1131

How would you load a very large file in teradata in general?

1091

Explain some differences between mpp and smp?

1157

What are the different table types supported by teradata?

1021

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1145

What is spool space?

1223

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

1041

What is difference between user and database in teradata?

1117

What are the advantages of teradata?

1060

Explain teradata vs. Redshift?

1078

how many modules are there in telecome domain?how to explain the architecture?

2065

What is the difference between teradata and basic rdbms?

1074

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

1091

What is database exceptions in teradata?

1002

What are the different functions performed in development phase?

1134