Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION dbo.najwiecej_spraw () RETURNS VARCHAR(100)
- AS
- BEGIN
- RETURN (SELECT TOP 1 se.nazwisko FROM
- sedzia se INNER JOIN sprawa sp ON se.id_sedzia=sp.id_sedzia
- GROUP BY se.id_sedzia, se.nazwisko
- ORDER BY COUNT(sp.id_sprawa) ASC)
- END
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement