Latest Answer: Select top1 * from in SQL Server ...
How many joiner transformations do we require to join 15 source tables , and they can be 7 flat files , and other may come from different sources ?
Latest Answer: select sum(sal) from (select distinct sal from emp order by sal desc) where rownum < 4try this ...
Latest Answer: hi, IN is used to pick one by one value from a list of values.Supports numbers,chars,dates.It is a special operator. Exists: It is also a special operator but it returns a BOOLEAN value. ...
How to list all the records from this mysql table.it has main categories and subcategories, wich are identified by parent id and how deep they go.I am using php mysql.So how can i list them where each child is listed under parent id. like a tree menu right.tbl categories-----------------------------------------------------| id | cat_name | parent_id | depth |------------------------------------------------------| 1 | Mobiles | 0 | 0 |-------------------------------------------------------| 2 | Computers
How can we use Crystal Reports or Business Object to simplying the column names that are displayed in CR. We use an ODBC driver to connect to a propiteary database and it works find but all the column names are in techo-speak !
How to calculate the power of decimal number?There is a function power(numeric,power) but when I use {select power(2.5,3)} truncate error occures but it works on power(2,3)
View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>
Go Top
