help in writing sql select statement
Hi,
Can someone please help me write this sql statement?
SELECT DISTINCT sss.user_name, 1,
(SELECT COUNT (user_name)
FROM saved_searches
WHERE sss.user_name = 'TESTADM' AND ROWNUM = 1),[over here I need sequential nos 1,2,3 for each row]
FROM saved_searches sss
ORDER BY (SELECT COUNT (user_name)
FROM saved_searches
WHERE sss.user_name = 'Phil Watson' AND ROWNUM =1) DESC,
sss.user_name;
This query shouls give the result as follows:
USER_NAME|1|SELECT COUNT (user_name)|Column that I want to add
TEST1 1 1 1
TEST2 1 0 2
TEST3 1 0 3
Thanks a lot for your help. I just need to know how to add the last column .