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
7072 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

What are the components provided on node?

1020

Explain the most common data types used in teradata?

1043

What is the maximum number of dml can be coded in a multiload script?

1089

What is logical data model?

1186

What are the updated features of teradata?

1027

Describe the set operators in teradata.

989

Explain the term 'foreign key' related to relational database management system?

1015

Difference between stored procedure and macro?

1149

Explain parsing engine in teradata?

1069

What is the syntax for case when statement?

1111

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

1082

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2094

What are the steps involved after the disk manager passes the request?

1092

What is a node in teradata? Explain

977

What are the available primary index types?

1200