Riddhi Valecha

Riddhi Valecha

  • 442
  • 3.3k
  • 415.1k

SQL Query - Urgent

Jun 15 2013 5:06 AM
Hi all...

I need help in formatting a sql query.

I have a table EMP in SQL Server as below.

ID      
FName
LName
Salary
1
ABC
PQR
12
2
DEF
STU
23

Now, I want to fire a query in a way that I get the results in the following format -

ID - FName
1 - ABC
2 - DEF
-----------
I am not able to get that "-" sign. PLease Help.

Thanks in advance.


Answers (5)