Latest Answer: A candidate key is a unique identifier that could be used as a primary key, which when you choose the primary key, the rest will then just be data fields ...
Latest Answer: select sname,phone,feebal,feepaid from student s left outer join fees fon s.sid=f.sid;union select sname,phone,feebal from student s right outer join fees f on s.sid=f.sid;u can use this compile code ...
Latest Answer: as row id is in oracle same as id is in mysql but in mysql there is no concept of rownum ...
Latest Answer: SELECT c1.CategoryID, c1.Name, c2.CategoryID, c2.NameFROM category AS c1, category AS c2WHERE c1.CategoryID = c2.ParentIDORDER BY c1.CategoryID, c2.CategoryID ...
select salary from tablename order by desc limt 4;
Latest Answer: select sal from emp order by sal desc limit 3, 1;This will select the 4th highest salary from emp table, i.e picks up after the third, next value ...
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?
View page [1] 2 3 4 5 Next >>
Go Top
