Search:

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

Search: Search took 0.00 seconds.

  1. PeopleSoft Re: Can you change the format of the date field

    neelvizhi,

    Did you mean is it advisable to change the format? Or do you want to know how to do it?

    Please explain bit further.

    Regards,
  2. PeopleSoft Re: Can you change the format of the date field

    Did you mean is it advisable to change the format? Or do you want to know how to do it?

    Please explain bit further.

    Regards,
  3. Answers
    3
    Views
    5,263

    Oracle Re: Oracle Null and Unique value

    Did u verify before Altering the table taht there are no records in table with NULL RollNumbers?
  4. Answers
    3
    Views
    3,575

    Data Warehousing - Re: hi everybody.

    Keep searching the forums of your interests . Try to interact with the members here , and the most important of all Keep Posting your queries.


    Keep reinventing :)

    Regards,
  5. Answers
    3
    Views
    3,575

    Data Warehousing - Re: Verify tables in Impromptu

    Do you mean data consistency across tables in the databases???
  6. DB2 - Re: Get records from table month, day, year wise.

    Sunil ,
    Did you mean that you want fetch records only for perticular month / year / day?
    If yes,

    To get the records for for perticular month


    Select * from my_table where...
  7. Answers
    3
    Views
    7,341

    Re: ahead in life

    Well said yogi.
    Keep up the spirit.

    Regards,
  8. Re: How I could get a software development job asap

    Keep Urself updated always , keep working hard and Keep praying.
    And share ur success stories with us.

    All the best.
  9. Answers
    5
    Views
    7,953

    SQL Re: which is more suitable IN or EXIST in SQL?

    IN clause is generally used to return values which are used as parameters for selecting another set of records. As follows
    SELECT emp_name FROM employees where emp_id IN ( select emp_id FROM...
  10. Answers
    2
    Views
    3,273

    SQL Server - Re: Full Text Searching

    Hey ,

    One thing about SQL Full Text Searches is it aids linguistic searches.



    HTH :)

    Regards,
  11. Answers
    2
    Views
    3,273

    SQL Server - Re: Full Text Searching

    One thing about SQL Full text searching is that aids linguistic searches in SQL server.

    HTH :)

    Regards,
  12. Answers
    2
    Views
    3,370

    SQL Server - Re: Unique with NotNull??

    Yes, Unique + NOT NULL is equivalent to primary key on a table ,though not explicitly declared. U can always use this column to retrieve a unique row from given table.


    HTH :)

    Regards,
  13. Answers
    4
    Views
    170,747

    SQL Server - Re: Why Truncate is DDL?

    Glad I could help :)


    Keep inventing.

    Regards.
  14. Answers
    4
    Views
    170,747

    SQL Server - Re: Why Truncate is DDL?

    Where DELETE statement deletes rows from table matching specifications in WHERE clause .
    TRUNCATE deallocates memory page(s) allocated for the specific table in memory and hence it is a DDL...
  15. Answers
    3
    Views
    11,635

    SQL Server - Re: SQL Server outer join

    Outer joins are generally used to retrieve data from one table thoug there is no matchind row in left or right table.

    You can access this link for Further information
    ...
  16. Answers
    16
    Views
    7,225

    SQL Server - Re: Find 2nd Highest in sql server

    Sutnarcha , barbies query will give you correct results no doubt .
    But VCyogi has given you a generic / more flexible query with wich you can get n-th higest / lowset salaray. It is just the...
Results 1 to 16 of 16
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