Обсуждение: How I write pretty query.

Поиск
Список
Период
Сортировка

How I write pretty query.

От
Radovan Petrikí
Дата:
Hi , 


I have table 

------------------
id     |  name 
------------------
1         rado 
2         marek
3         pista 

I need make query. Your output is only (true or false) 

This 2 query are good but no pretty.

1)    SELECT COUNT(*) FROM table WHERE name=rado 
         -------------output      -->    COUNT(*)   1 

or 

2)    SELECT name FROM table WERE name=rado 
        -------------output       -->   name   rado 





and this is pretty query :-) buy no good.
SELECT (true or false) FROM table WHERE name=rado
        --------------output ---->        true 

How I write good and pretty query ? 

Thanks 

Rado