Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 sql query

Author  Topic 

mahabub
Starting Member

1 Post

Posted - 2011-09-03 : 01:22:58
Please give me solution if anybody can solve following query :
Create a query that displays the first eight characters of the employees last names and indicates the amounts of their salaries with asterisks. Each asterisk signifies a thousand dollars. Sort the data in descending order of salary. Label the column EMPLOYEES_AND_THEIR_SALARIES.

mahabub

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-03 : 05:31:03
sounds like homework. please show what you tried so far. we dont appreciate giving spoonfed answers to homework questions

Hint can be given like you need to use LEFT() function and REPLICATE() function

look for syntax and usage in books online

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -