Showing results for tags 'sqlserver'.

Found 3 results

self join with multiple left outer joins

Hiral posted a topic in SQL

PLEASE HELP IN A QUERY. i AM TRYING TO DO SELF JOIN WITH A QUERY WHICH 2 OR MOR ELEFT OUTER JOINS IN IT. HOW TO DO SELF JOIN HERE . THANKS IN ADVANCE.
- March 4, 2019
- 1 reply
- - sql
  - sqlphp
  - (and 5 more)
    Tagged with:
    
    sql
    
    sqlphp
    
    sqlite
    
    sql2008
    
    sqlserver
    
    sql code...
    
    sql query
Free SQL Book - Great For Beginners

joe_lorez posted a topic in SQL

Hey everyone, I wanted to share with everyone the book "SQL QuickStart Guide" that is currently free in the Amazon Kindle store. You can download here: http://www.amazon.com/SQL-QuickStart-Guide-Simplified-Structured-ebook/dp/B00UCFK44U/ref=sr_1_18?s=digital-text&ie=UTF8&qid=1427911263&sr=1-18&keywords=sql
- April 1, 2015
- - sql
  - sqlserver
  - (and 4 more)
    Tagged with:
    
    sql
    
    sqlserver
    
    mssql
    
    msaccess
    
    oracle
    
    php
How To Get Row Output In Single Row

rajkumarrajendran posted a topic in SQL

select mainline+'/'+subline from table1 where mainline='54326'Here I m getting output like thiso/p:Mainline 54326/154326/2the above query i m getting output in two linebut i need an single line output like i mentioned below Mainline54326/1, 54326/2anybody please post solution for this.....

Search the Community