Search the Community
Showing results for tags 'sqlserver'.
-
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.
-
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
-
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.....