Search:

Type: Posts; User: jaideepu; Keyword(s):

Search: Search took 0.24 seconds.

  1. Answers
    3
    Views
    1,734

    SQL Re: SQL Order By Clause

    If category_name column is in categories table it will work

    "SELECT * FROM categories WHERE category_id NOT IN("SELECT category_id FROM company_categories WHERE company_id=1") ORDER BY...
  2. Thread: sql

    by jaideepu
    Answers
    3
    Views
    1,425

    SQL Re: sql

    A composite key has more than one attribute (field). In this example we store details of tracks on albums - we need to use three columns to get a unique key - each album may have more than one disk -...
  3. Answers
    25
    Views
    20,816

    SQL Re: how to display 2nd row in the table

    SELECT TOP 1 *
    FROM emp
    WHERE ENAME NOT IN (SELECT TOP 1 ENAME FROM emp )



    This is in SQL server
  4. Answers
    3
    Views
    1,534

    SQL Re: pls anseer this query.............

    SELECT a.empno,a.ename,a.salary FROM
    (select empno,ename,row_number() OVER(order by salary desc) rn,salary from emp)a
    WHERE rn=1 OR rn = 2
  5. Answers
    3
    Views
    1,267

    SQL Re: Query for review date.......

    1 select employeeid, empfirstname, emplastname, emphiredate,
    2 add_months (emphiredate,6) REVIEW,
    3 from employees
    4* WHERE MONTHS_BETWEEN (SYSDATE, emphiredate)
  6. Thread: Sort in Order

    by jaideepu
    Answers
    6
    Views
    1,370

    SQL Re: Sort in Order

    Select * from presons order by p_id
  7. SQL Server - Re: create a table with 3 column where sum of 2 column is 3rd column

    now i got the answer


    this is the answer


    CREATE TABLE sample6
    (
    col1 int ,
    col2 int,
  8. SQL Server - Re: create a table with 3 column where sum of 2 column is 3rd column

    I need while creating the table, it have to effect the data base table
  9. SQL Server - create a table with 3 column where sum of 2 column is 3rd column

    create a table with 3 column where sum of 2 column is 3rd column

    ex
    col1 col2 col3
    1 2 3
    3 4 7
    2 2 4
  10. SQL Server - List all the job groups who average salary exceeds that of managers.

    List all the job groups who average salary exceeds that of managers.

    Empno ename job manager hiredate salary deptno commission
    7369 smith clerk 7902 12/1/1982 ...
  11. Answers
    7
    Views
    1,633

    SQL Server - Re: display deptname

    Thanks pradeep
  12. Answers
    2
    Views
    1,330

    SQL Server - Re: Display date with the day

    select ename,role,DATENAME(Day, hiredate)
    + CONVERT(VARCHAR(12), hiredate, 107) as hiredate from emp where deptno = 20

    it is showing output like this

    smith clerk 1Dec...
  13. SQL Re: A Simple Query (If any 1 can answer) PLEASE !!

    how we can do this in sql server 2005
  14. Answers
    7
    Views
    1,633

    SQL Server - Re: display deptname

    Select top 1 deptname, count(employee) as total from Employee group by deptname order by total.


    hear we will get jest top one departname and count of employes but we need higest count of...
  15. Answers
    2
    Views
    1,330

    SQL Server - Display date with the day

    List department 20 employee’s jobs and hire dates formatted like “WEDNESDAY January 12, 1983”

    how to display this please post the query

    thanks,
    JaiDeepu
  16. Re: When will be we going to use Step Generator?How to use it?

    Open QTP
    Insert-> step Generator

    Category= utility objects (from drop down list)
    Object=System util
    operation= Run

    Arguments
    File: value=IEXPLORE.EXE
    params: value=www.google.com
  17. Answers
    11
    Views
    26,743

    Re: Execute file Method in QTP

    For i=1 to 2
    Call MyFunction("Hello World")
    ExecuteFile "C:\Documents and Settings\jaideepu.namineni\Desktop\Bpt.vbs"
    Next

    Function MyFunction(text)
    MsgBox text
    End Function

    it will...
  18. Answers
    11
    Views
    26,743

    Re: Execute file Method in QTP

    Call MyFunction("Hello World")
    Function MyFunction(text)
    MsgBox text
    End Function
    ExecuteFile "C:\Documents and Settings\jaideepu\Desktop\hello.vbs"


    It will execute the hello.vbs Also
  19. Answers
    2
    Views
    1,406

    Re: Components...........

    This will use full for u keyword view keyword view sc (click business components in the qc
    create the folder by clicking the give the name create the component by clicking on give the name give:-...
  20. Re: When will be we going to use Step Generator?How to use it?

    The Step Generator dialog box helps you add steps that use test object methods, Utility object methods, and function calls, so that you do not need to memorize syntax or to be proficient in...
  21. Answers
    11
    Views
    26,743

    Re: Execute file Method in QTP

    If you decide not to associate a function library (any VBScript file) with a test, but do want to be able to call its functions, subroutines, and so forth from an action in your test or from another...
  22. Answers
    2
    Views
    6,017

    Re: How to compare two pdf files with using qtp

    public function FileComparison(in File1, inFile2, out Result)
    {
    auto SaveFile = "Somefile in which the compared files are saved for future viewing."

    Result = file_compare(File1, File2,...
Results 1 to 22 of 22
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact