```
CREATE TABLE t1 (s1 INT, s2 CHAR(5) NOT NULL);
INSERT INTO t1 VALUES(100, 'abcde');
SELECT (SELECT s2 FROM t1);

```

when i am executing in MySql DB its giving syntax error like 1065
the select statement is not executing,
this is call scalar sub queries according to MySql
follow link for more info
<http://dev.mysql.com/doc/refman/5.1/en/scalar-subqueries.html>