Trending PostgreSQL Discussions

How do I get 0 instead of null in this query?‎

Answers:

20

Followers:

5

Views:

466

Vote Count:

7

How do I find second highest value from a table?‎

Answers:

5

Followers:

7

Views:

148

Vote Count:

8

Why it is preferred to create a table space on a partition other than the system partition?‎

Answers:

2

Followers:

2

Views:

66

Vote Count:

0

How to get last three month records from a table? ‎

Postgresl / mySQL / Oracle‎

Answers:

11

Followers:

5

Views:

629

Vote Count:

5

How can I get the value for aggregate query in Yii if the aggregate value not an attribute on the activerecord class?‎

$criteria = new CDbCriteria(); $criteria->select = 'type , seen, count(1) As counts'; $criteria->condition = 'mb = :mb AND deleted = false AND arc‎ ... See More

Answers:

1

Followers:

2

Views:

1506

Vote Count:

4

What are the differences between Oracle , MSSql , MySql , Access and postgresql, please compare by the following points ?‎

Points are : (1) - number of the computers ( clients ) that I can Connect To that database (2) - security that make that database special (3) - command that help to make ‎ ... See More

Answers:

4

Followers:

4

Views:

1984

Vote Count:

3

What do you mean by NOSQL database?‎

Explain with illustrations/examples‎

Answers:

3

Followers:

5

Views:

152

Vote Count:

2

How to perform the Delete dml in postgres and get the number of deleted rows at the same time?‎

Answers:

1

Followers:

1

Views:

130

Vote Count:

0

What database aspects should be monitored?‎

Answers:

2

Followers:

1

Views:

139

Vote Count:

4

What database block size should I use?‎

Answers:

3

Followers:

1

Views:

330

Vote Count:

4