Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 7077 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / babu
Hi,
sel no,name from table group by no,name order by no,name;
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / 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 |
Answer / tdguy
use distinct or group by to avoid duplicates in teradata.
| Is This Answer Correct ? | 1 Yes | 0 No |
Highlight all the modes that are present under Confidence Level.
Find 2 highest sal from each dept who have completed 5 year in org
What are normalization, first normal form, second normal form and third normal form?
Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Why AMP & PE are called Vprocs?
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?
What is the use of having index on table?
A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
What is spool space? Why do you get spool space errors?
Where is teradata rdbms used?
What is the difference between teradata and oracle?
Teradata 
