Search:

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

Search: Search took 0.01 seconds.

  1. Answers
    5
    Views
    21,481

    SQL Server - Re: Insert of multiple records in single query

    insert into tablename values('&name&','&no&')
  2. Answers
    15
    Views
    5,017

    SQL Server - Re: Delete duplicate record

    DELETE FROM tablename WHERE rowid not in(SELECT MIN(rowid)FROM tablename GROUP BY column1,column2 )
  3. Answers
    16
    Views
    4,679

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

    SELECT UnitPrice where rownum<2 FROM (SELECT TOP 2 UnitPrice FROM Products ORDER BY UnitPrice );
  4. Answers
    16
    Views
    4,679

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

    SELECT top 1 UnitPrice FROM (SELECT TOP 2 UnitPrice FROM Products ORDER BY UnitPrice DESC)
  5. Answers
    3
    Views
    4,311

    SQL Server - Re: copy the Table Structure

    create table tablename 1 from select * from tablename2
Results 1 to 5 of 5
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