In SQL, which of the following syntax is correct for the count sid? A. SELECT COUNT(sid), gender FROM tblseller WHERE gender = ‘male’ B. SELECT COUNT(sid), gender FROM tblseller GROUP BY gender = ‘male’ C. SELECT COUNT(sid), gender FROM tblseller…
In SQL, which of the following syntax is correct about group by sid of tblseller? A. SELECT COUNT(sid), gender FROM tblseller B. SELECT COUNT(sid), gender FROM tblseller IN GROUP gender C. SELECT COUNT(sid), gender FROM tblseller GROUP BY gender D.…
In SQL, which is correct about order by name in table tblseller? A. SELECT * FROM tblseller ORDER BY name WHERE name = ‘meta’ B. SELECT * FROM tblseller WHERE name = ‘meta’ ORDER name C. SELECT * FROM tblseller…
In SQL, how to select multiple attributes from tblseller? A. SELECT sid & name FROM tblseller B. SELECT sid AND name FROM tblseller C. SELECT sid, name FROM tblseller D. None correct Answer: Option C
What syntax is correct to filter the seller’s name is not ‘meta’? A. SELECT * FROM tblseller WHERE name != ‘meta’ B. SELECT * FROM tblseller WHERE name >< 'meta' C. SELECT * FROM tblseller WHERE name ‘meta’ D. None…
In SQL, What syntax is correct for filtering seller name’s meta or male? A. SELECT * FROM tblseller WHERE name = ‘meta’ | gender = ‘male’ B. SELECT * FROM tblseller WHERE name = ‘meta’ || gender = ‘male’ C.…
What syntax is correct for filtering seller name’s meta and male? A. SELECT * FROM tblseller WHERE name = ‘meta’ & gender = ‘male’ B. SELECT * FROM tblseller WHERE name = ‘meta’ && gender = ‘male’ C. SELECT *…
What is the correct syntax for SQL for theta join of tblseller and tblsell? A. SELECT * FROM tblseller C & tblselling B WHERE C.sid = B.sid B. SELECT * FROM tblseller C, tblselling B WHERE C.sid = B.sid C.…
What code is correct in SQL language joining tblseller and tblsell? A. SELECT * FROM tblseller OUTER JOIN tblsell B. SELECT * FROM tblseller C LEFT OUTER JOIN tblsell B ON C.sid = B.sid C. SELECT * FROM tblseller LEFT…
What code is correct in SQL for joining tblseller and tblsell? A. SELECT * FROM tblseller JOIN tblsell B. SELECT * FROM tblseller INNER JOIN tblsell ON tblseller.sid = tblsell.sid C. SELECT * BETWEEN tblseller AND tblsell ON tblseller.sid =…
KB Cambodia