skip to main
|
skip to sidebar
Tuesday, March 27, 2012
distinct years
in my table I have a column Dates
10/03/2004 18:35:00
how can I get the list of Distinct years ?
2001
2002
2003
2004
thank youselect distinct year(Dates) from yourtable|||it works !
thank you
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
distributed transaction
distributed transaction,sql server
Blog Archive
▼
2012
(641)
▼
March
(416)
Distributed Query Connection Issues
Distributed Query Connection Issues
Distributed query against loopback linked server i...
Distributed query & OLE DB provider
Distributed Query
Distributed Query
Distributed Query
Distributed query
distributed queries in win 2003 and win 2000
distributed queries in win 2003 and win 2000
distributed queries in win 2003 and win 2000
Distributed queries
Distributed Queries
Distributed queries
Distributed queries
distributed queries
Distributed processing "farm" using Broker for mid...
Distributed processing "farm" using Broker for mid...
Distributed Partitions (Across multiple servers)
distributed partitioned views
Distributed partitioned views
distributed partitioned view pblm
distributed partitioned view + procedure
Distributed Partioned Views between different SS v...
Distributed Partioned Views between different SS v...
Distributed Partioned Views between different SS v...
distributed install - connection error
Distributed insert on oracle DB does not work from...
Distributed FULL OUTER JOIN results in INNER join
Distributed ETL server
Distributed databases?
Distributed databases in a cluster
Distributed databases
Distributed databases
Distributed databases
distributed database
distributed database
distributed database
distributed database
distributed database
Distributed data synchronization - Comparing times...
Distributed data synchronization - Comparing times...
Distributed Broker Queue Performance Issue
Distributed App, Technology Question
Distributed APP strategies-What to do where is kil...
distribute the part of data to different database ...
distribute the part of data to different database ...
distribute the part of data to different database ...
Distribute ReportBuilder
Distribute ReportBuilder
Distribute Print ActiveX control to masses
distribute in a page..
distribute in a page..
distribute in a page..
Distribute Data Securely in SSExpress
Distribute backup on multiple disks
Distribute app/database with SQL or Windows security?
distrib.exe taking 100% of CPU
distrib.exe Many instances running
distrib.exe & logread.exe
distrib.exe
distrib. agent remains stopped
Distrib agent question
Distinguishing Processors in Server Properties
Distinguishing Processors in Server Properties
Distinguishing Processors in Server Properties
Distinguish User Objects and System objects
Distinguish User Objects and System objects
Distinguish SQLServer and MSDE instances
Distinguish changes by replication and changes by ...
distinguish between the Publisher and the Subscribers
Distincts databases on the same stored procedure
DistinctCount
Distinct?
Distinct?
Distinct?
distinct: removing dups
DISTINCT() Question
distinct years
DISTINCT w/ character data
DISTINCT values from a table
distinct values from a join
DISTINCT Values
Distinct Value of each column !
Distinct Value of each column !
Distinct Value of each column !
DISTINCT Value
Distinct Type Count
Distinct Total
Distinct Total
DISTINCT to ShortDateString, not DISTINCT to the D...
Distinct Sum for my column
Distinct Sum - How To?
Distinct Sum - How To?
Distinct Selection in SELECT
distinct select statement of households
distinct select statement of households
Distinct Rows but All Columns
distinct row count in a table.
DISTINCT returns duplicates
►
February
(225)
About Me
sque
View my complete profile
loan
sql
sql server
sql
sql server
sql
imwebhost
No comments:
Post a Comment