Questions in topic: select - SQL Server Q&A from the SQL Server Central community

Questions in topic: select

votes

answers

views

How to retrieve data value from a previous row with select statement

May 12 at 03:54 PM ccmalls32 (suspended)

sql-server-2000 tsql select

votes

answers

views

Problem using joins when use multiple tables

Apr 25 at 10:52 AM Grant Fritchey ♦♦ 62.2k

sql-server-2008 joins select

votes

answers

117

views

Convert Password nvarchar() to binary datatype in sql

Apr 24 at 11:57 AM buyme154 (suspended)

sql-server-2008 sql-server select hash

votes

answers

146

views

Create select query how to convert varchar to int by using cast

Apr 16 at 10:20 AM udhaya 80

sql-server-2008 select substring cast

votes

answers

132

views

dynamic sql to retrieve tablenames

Mar 04 at 01:36 AM Mandar Alawani 346

insert select meta-data tablenames dynamic sql

votes

answers

290

views

Help - Need a better way to create Query. Select within a Select

Feb 24 at 07:23 PM whitter 40

select

votes

answers

193

views

How to select decimal record in a table

Feb 19 at 08:16 PM ThomasRushton ♦ 29.4k

sql-server-2008 query select

votes

answers

182

views

Top 10 records in one row

Jan 30 at 03:25 PM liton 570

select top

votes

answers

111

views

CASE WHEN FIELD IN(..) SELECT Statement

Jan 23 at 07:41 AM ThomasRushton ♦ 29.4k

select case in

votes

answers

198

views

Select * and column in different tables.

Jan 21 at 01:11 PM Fatherjack ♦♦ 38.8k

joins select columns

votes

answers

112

views

I am getting this error " 10:30:26 [SELECT - 0 row(s), 0.000 secs] [Error Code: 156, SQL State: S1000] Incorrect syntax near the keyword 'FROM"

Jan 17 at 10:36 AM clothesbiz11 (suspended)

select

votes

answers

271

views

Difference between SELECT Alias = ColumnName and SELECT ColumnName AS

Jan 10 at 11:51 AM Grant Fritchey ♦♦ 62.2k

sql-server-2008 select

votes

answers

views

Departmentwise 2nd highest salary

Dec 08 '12 at 12:45 PM gloing59 (suspended)

t-sql select

votes

answers

153

views

How to select in a n-n ids structure with multiple AND?

Nov 13 '12 at 11:37 AM Kev Riley ♦♦ 46.1k

select mysql

votes

answers

1.1k

views

How to Select unmatched data from two column in two table

Oct 17 '12 at 03:50 PM Fatherjack ♦♦ 38.8k

select

votes

answers

208

views

Query - change colums based on content

Sep 14 '12 at 11:59 AM Grant Fritchey ♦♦ 62.2k

select

votes

answers

350

views

Filtering data based on criteria.

Aug 31 '12 at 03:32 PM Fatherjack ♦♦ 38.8k

select sql server union case

votes

answers

246

views

How to select rows from a table from other table key column value +1

Aug 16 '12 at 06:26 PM Grant Fritchey ♦♦ 62.2k

select

votes

answers

539

views

I have a email database

Aug 09 '12 at 11:53 AM Usman Butt 13.8k

query select homework mysql join

votes

answers

199

views

Not in Select Statement

Aug 07 '12 at 01:01 PM Fatherjack ♦♦ 38.8k

select

votes

answers

649

views

When using a static column with SELECT, why can't I access that column from WHERE clause?

Jul 21 '12 at 06:08 PM Scot Hauder 5.7k

select mysql subquery

votes

answers

661

views

inner join vs a select with a bunch of tables specified and a where clause

Jul 19 '12 at 09:54 PM adrianh 20

select join

votes

answers

407

views

Efficiently Searching Database

Jun 06 '12 at 01:50 PM Fatherjack ♦♦ 38.8k

sql select

votes

answers

3.2k

views

Best MySQL practice to insert a record if it does not already exist, and return its id

Apr 29 '12 at 12:36 PM stevenjgarner 10

update insert select mysql unique

votes

answers

403

views

Select Statement, Where clause help - need to select active projects & closed projects from this year

Mar 20 '12 at 12:57 AM TelepathicSheep2 140

select where

votes

answers

318

views

SQL Data retrieval

Jan 20 '12 at 01:58 AM Meena 21

select

votes

answers

413

views

SQL Select Statement with Multiple Joins Help Needed

Jan 14 '12 at 12:18 PM stanlyn 11

joins select

votes

answers

774

views

Dynamic Table Optimization - Select *

Jan 13 '12 at 06:04 AM katie 2 74

sql-server-2008 select dynamic-sql temporary-tables

votes

answers

978

views

Removing Repeated Identical SubQueries From A Query?

Nov 10 '11 at 09:36 AM David 2 1 314

t-sql sql-server-2000 select sub-query where

votes

answers

824

views

Select many(>1000) columns from table

Sep 29 '11 at 02:06 AM Nick77 11

sql-server-2008 select columns

votes

answers

442

views

Select and set in column

Jun 09 '11 at 08:01 AM Fatherjack ♦♦ 38.8k

select

votes

answers

580

views

Row count < 1 Return 0

Apr 13 '11 at 09:45 PM Pavel Pawlowski 20.3k

select row-counts

votes

answers

1.9k

views

Select with sum from one table, Select single field from another

Mar 31 '11 at 02:16 PM Oleg 15.4k

select

votes

answers

501

views

Select query

Mar 28 '11 at 01:16 AM Fatherjack ♦♦ 38.8k

tsql select

votes

answers

views

Avoid a Divide by Zero Exception using Select Statement

Mar 24 '11 at 12:10 PM technette 847

select

votes

answers

372

views

Select Statement that Totals on columns?

Mar 17 '11 at 09:59 AM technette 847

select

votes

answers

1.8k

views

patindex and substring

Mar 07 '11 at 12:39 PM Fatherjack ♦♦ 38.8k

select substring patindex

votes

answers

906

views

Select Statement from Large Table for DropDownList

Mar 02 '11 at 08:49 AM technette 847

select

votes

answers

6.2k

views

How To Select Data After A Character

Jan 20 '11 at 02:27 AM David 2 1 314

t-sql sql-server-2000 select

-1

votes

answers

1.8k

views

Select statement which ansrews this question!!

Oct 22 '10 at 03:58 PM Blackhawk-17 10.5k

select homework

votes

answers

1.9k

views

How can I replace a nested select with a join

Oct 08 '10 at 01:14 AM Fatherjack ♦♦ 38.8k

t-sql joins select

votes

answers

1.9k

views

Select and Concatenate, easy

Sep 23 '10 at 03:49 AM Kev Riley ♦♦ 46.1k

select concatenation

votes

answers

4.5k

views

How to concatenate values of a same column

Sep 23 '10 at 03:48 AM Kev Riley ♦♦ 46.1k

select concatenation

votes

answers

1.2k

views

SELECT * v SELECT Columns

Sep 01 '10 at 08:26 AM Håkan Winther 15k

performance select best-practice

votes

answers

847

views

Exporting data to a linked iSeries server

Aug 13 '10 at 02:31 PM Dave Myers 123

select export-data db2

votes

answers

1.1k

views

Selecting data from tablenames and columns listed in a table

Jul 16 '10 at 05:17 AM Kev Riley ♦♦ 46.1k

select dynamic tablenames

votes

answers

697

views

SQL pulling data

Jun 21 '10 at 02:49 PM Hung 1

sql-server-2005 sql-server-2008 ssis backup select

votes

answers

views

Joining across two databases and multiple tables

Jun 17 '10 at 03:30 PM Kev Riley ♦♦ 46.1k

sql-server-2005 joins select view

votes

answers

1.2k

views

Select data from three tables

Jun 14 '10 at 03:17 AM coolcurrent 1

joins select

votes

answers

1.1k

views

how to create a view without using CASE * updated*

Jun 02 '10 at 11:25 AM pete 1 1

sql-server-2000 select aggregates case-statement

87 questions

176answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags