How to select Distinct columns from the table, table having 20 columns an

Advertise your Business Here

Refer this Site

Login | Sign Up


	Ask Questions on ANYTHING, that arise in your Daily Life at FORUM9.COM

Categories >> Software >> Databases >> SQL Server

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

How to select Distinct columns from the table, table having 
20 columns and i want all coulmns

Question Submitted By :: Bhaskar

I also faced this Question!!

Rank

Answer Posted By

Re: How to select Distinct columns from the table, table having 20 columns and i want all coulmns

Answer
# 1

select distinct * from table_name

Is This Answer Correct ?

11 Yes

5 No

Amit

Re: How to select Distinct columns from the table, table having 20 columns and i want all coulmns

Answer
# 2

To select distinct columns you can mention them in the SQL
query and to select all columns you can use select * from
information_schema.columns

Is This Answer Correct ?

2 Yes

6 No

Monal

Re: How to select Distinct columns from the table, table having 20 columns and i want all coulmns

Answer
# 3

select distinct * from tablename;

Is This Answer Correct ?

2 Yes

1 No

Latha.s

Question	Asked @	Answers
Other SQL Server Interview Questions


in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.		7
Can Somebody tell me the difference between Clustered & Non- Clustered Index??	Progressive	3
can primery key be a non clustered index?		8
What is the difference between constraints and triggers?	Wipro	6
How to get the count of distinct records. Please give me the query?	Value-Labs	5
SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES	Microsoft	1
How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?		3
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)	McAfee	5
hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju		3
When you first load SQL SERVER you will startup with what all databases?	CompuSol	3
What is a cursor in SQL Server 2000 and their types?		4
What is referential integrity? What are the advantages of it?	Digital-Domain	3
how to retrive only second row from table in sql server 2000?	CTS	7
can you any body tell me the difference between candidate key and primary key		4
what is the cursor life span?	Evalueserve	5
How can i change the column name.	HCL	7
What is BCP? When do we use it?		1
how to find number of columns in a table in sql server 2000 and 2005 also	Virtusa	7
How do you persist objects, permissions in tempdb		1
how to connect sybase to sql server 2005?.	ABC	1

For more SQL Server Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com