SQL QUERY Help

Question

1.00/5 (3 votes)

See more:

Can anyone help regarding this SQL query:
Given table:

EmpID -- EmpName
1 -- LG
2 -- NOKIA
3 -- Samsung
4 -- TATA

Our output should be:
LG, NOKIA, Samsung, TATA

Also can you provide some useful resource for SQL Interview Queries.

Thanks in advance :)

Posted 15-Oct-10 8:29am

nitinbalodi

Updated 15-Oct-10 8:31am

v2

Add a Solution

Comments

HimanshuJoshi 15-Oct-10 14:57pm

Get a book on SQL query and study it completely.

3 solutions

Solution 3

this link will be useful to mastering sql

Posted 15-Oct-10 9:36am

alrosan

Solution 4

Use a cursor and string concatenation.

Posted 15-Oct-10 9:40am

AspDotNetDev

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

William Winner · Accepted Answer · 2010-10-15T08:42:00

Solution 1

wait...what? you just want

SQL

SELECT EmpName FROM TableName ORDER BY EmpName ASC

or

SQL

SELECT EmpName FROM TableName ORDER BY EmpID ASC

If that's the case, then here's the only answer you need for an interview over SQL:

I don't know anything about SQL

Posted 15-Oct-10 8:42am

William Winner

Comments

HimanshuJoshi 15-Oct-10 14:55pm

I upvoted you to counter vote the stupidity.

SQL QUERY Help

3 solutions

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0

SQL QUERY Help

3 solutions

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us