select salary from tablename order by desc limt 4;
Latest Answer: select distinct a.sal from emp a where n=(select count(distinct b.sal) from emp b where a.sal
Latest Answer: hey,here it is :--select/update/delet/insert- from-where-group by-having-order byI think this is the oder of the execution. ...
Latest Answer: if u r talking about setting different timezone from diff connection on same DB then i wont think its possibleAs per My knowledge Time zone settings are golbal and are applied server side ...
Latest Answer: For Mysql database, you can use mysqldump for that.See details with examples @ http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html ...
How do you reformat system date in MySQL?Explain various formats ..? how to add a date/hour/minute/second to a date?
Latest Answer: For the configuration of MySql these dependencies are required as:mysql-5.0mysql-server-5.0mysqlclient9-5.0mysql-devel-5.0php-mysql-5.0install by rpm -i vh mysql-server-5.0.rpm and others also sameIf configured in RHEL the .rpm are needed.if configured ...
Latest Answer: There are five types of db engines MyISAM(default type),INNODb,BDB,Heap,Mearge,Temproray ...
Latest Answer: mysql 4.0 onwards support subquery ...
Latest Answer: mysql5 support view and procedure where as 4 is not support ...
Latest Answer: A trigger is a named database object that is associated with a table and that is activated when a particular event occurs for the table. For example, the following statements create a table and an INSERT trigger. The trigger sums the values inserted into ...
View page << Previous 1 [2] 3 4 5 Next >>
Go Top
