how to generate sequence id without procedure?

SELECT
  ID
  ,sender
FROM 
SELECT 'squence ID' AS ID, 'blabla' AS se开发者_C百科nder
FROM A

The question: is it possible to somehow generate 'sequence ID' without any procedure?

---

You can use row_number(), like this:

SELECT row_number() over (order by sender) as Id, 'blabla' AS sender
FROM A